Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
triekong
Creator
Creator

Transition from 1 tab to the next

  i am trying to pass values in my transition from one tab to the next.

1st tab: summary

2nd tab: financial analysis (FA)

on the summary tab, i have 2 tiles. the 1st tile has Gross Costs in it. and the 2nd has Deployed payroll.

on the financial analysis tab, i have just 1 tile object.

TO-BE: when the 'Gross Costs' tile is selected, i want to pass all the value to the financial analysis tab. and when the 'Deployed Payroll' tile is selected, i want to pass all the values on that specific tile to the tile on the 'financial analysis' tab.

PROBLEM: to pass the values, i created a variable that stores the formula called: v_VariableTransfer

the issue is, the values. when Gross costs is selected, it is passing the value to the FA tab. but it stores that value in the variable. this means that when i try to change the filter on the FA tab now, the value does not respond to any value changes.

i need to be able to pass the formula and not the number itself.

let me know if anyone has a workaround for this, or has had to do it before.thanks!

attached is my QlikView App

3 Replies
jwjackso
Specialist III
Specialist III

Try changing the Set Variable for v_VariableTransfer to this:

=If(GetFieldSelections([Period])='YTD', '$(vCFYTD_WonGC)',

If(GetFieldSelections([Period])='QTD', '$(vCQTD_WonGC)',

If(GetFieldSelections([Period])='MTD', '$(vCMTD_WonGC)',

0)

)

)

Change the dimension Tile on the "Financial Analysis" to:

=$(v_VariableTransfer)

triekong
Creator
Creator
Author

thanks for the response.

the problem with that is, it's still saving the value in the variable.

Also, the expression above is only for the GC. How would i pass the Deployed Payroll expression?

thank you!

jwjackso
Specialist III
Specialist III

In your chart on the "Financial Analysis" tab, change the formula as below:

Capture1.PNG

When you select QTD on the Summary tab and select the "Gross Costs" tile, you selection will be reflected on the "Financial Analysis" tab.

Capture2.PNG

Capture3.PNG

You will need a transfer variable for each tile.