topic Re: Transition from 1 tab to the next in QlikView

Transition from 1 tab to the next

triekong — Wed, 21 Feb 2018 21:31:47 GMT

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

Re: Transition from 1 tab to the next

jwjackso — Wed, 21 Feb 2018 22:29:55 GMT

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)',

)

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

=$(v_VariableTransfer)

Re: Transition from 1 tab to the next

triekong — Thu, 22 Feb 2018 13:06:44 GMT

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!

Re: Transition from 1 tab to the next

jwjackso — Fri, 23 Feb 2018 12:13:44 GMT

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

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

You will need a transfer variable for each tile.