Passing values using "Submit" and also transition to another tabstrip

[Former Member]

Hi, I am new to VC and have some basic issues in my model.

I have used two layers, the first one for selection of data and the second one to disply the charts, using tabstrips. when I input the data in the first tab and click "Submit" pushbutton, I could not transition automatically to the second which shows the data. I found that onely one action can be set under custom action on the pushbutton. Is there a better way to do?

I could get the relevant documents when I searched. Please let me know how to achieve this. Thanks

KS

[Former Member · Accepted solution]

Hi

Why you want to use Layers & Tab representation? Is there any specific requirement for the Layer?Better & simple representation will be put that Chart & Form (OR Table) side by side. When you select the data & click 'Submit' button, you will get required output. If Chart & input are side by side its better for the user for representation.

Regards

Sandeep

[Former Member · Accepted solution]

Hi, Thanks for the quick reply.

the reason why I use layers is to use teh same selection for multiple queries to be used in multiple layers. To be precise, I am building a budget kpi dashboard, in which my seletion would be cost center and period, the different tabs would be for charts and tables by period (Plan vs actual, variance in currency, variance in %) and by quarter.

so I want to pass my selection to different tabs and also allow transition from first to second automatically and the to change teh seletion use another button to go back to tab 1 for selection (this is simple I know)

hope you can advise better now. tks

KS

[Former Member · Accepted solution]

Hi

Then Create different different 'Nested iViews' based on period & quarter (1 Nested iView for one Tab)

After you 'Input form' ues 'Data Store' Operator for each period. Then give the 'Visibility condition' for each 'Nested Iview' based on these data stores. Condition will be like -

bool(if(store@period==1,false,true)).

So when you select perticular period the relevent "Nested iView' will get executed based on the visibility condition which you have given. And also use 'Back button' to come back to main page.

There is another simple way - Create radio button with entry list for 'Period' or 'Quarter'. Create the charts as you want. Again create visibility condition based on these radio buttons. Assign default value in radio buttons so that that will opened as default. And when you deploy the model based on radio button selection you can control the visibility.

Regards

Sandeep

[Former Member · Accepted solution]

Hi

Thanks for the prompt replies, but sorry, I could not proceed with both the solutions as i am still a novice. Could yu send me some details/ step by step guidance on how to use these procedures?

regds

KS

[Former Member · Accepted solution]

Hi

Follow the steps below - (I am assuming that you are using BI queries in your model & your tabs are as per quarter - one tab for each quarter)

1. Create one radio button & in entry list create static list as 1 - Quarter 1, 2 - Quarter 2 & so on.

2. Now you want plan Vs actual in one graph & Currency in another. So create these reports for each quarter separately, so in all you will have 8 reports (2 for each quarter)

3. IN the layout you have to arrange it vary carefully, you take all the 'Plan Vs Actual' report for all the quarters & arrange them exactly one over the other. Same for Currency reports also.

4. NOw Give visibility condition for each report example - if report is for first quarter then condition will be - bool(if(radio button string=="1",true,false)) & assign the default value in radio button as 1. so that at the time of execution you will get these reports by default.

5. Like wise give condition for all.

6. When you execute this report you will get radio buttons at the top & as you select different buttons differents report will get opened.

7. As you have plased these exactly one over the other, user will not come to know these are different reports.

Try this method, if you have any doubts for this, please do ask me.

Regards

Sandeep