Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
triekong
Contributor

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
Highlighted
jwjackso
Valued Contributor

Re: Transition from 1 tab to the next

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)

Highlighted
triekong
Contributor

Re: Transition from 1 tab to the next

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!

Highlighted
jwjackso
Valued Contributor

Re: Transition from 1 tab to the next

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.