topic Re: Pre-define selection in Tab but allow changes in QlikView

Pre-define selection in Tab but allow changes

Wed, 06 Nov 2013 06:44:54 GMT

Hi,

I have a certain Tab that shows graphs regarding a certain ID (Max ID).

This condition is made in Set analysis.

Sum({$<RUN_ID={$(vMax_Run)}} OPCODE_COUNT*SUBSCRIBER_COUNT)

I want the user to be able to choose other Run ID to be reflected on the graphs, but by default to show the Max run ID.

How can I do it?

Thanks,

Boris

lironbaram — Wed, 06 Nov 2013 07:03:43 GMT

hi you can use a button that selects the max id , but the the user can change the id

oryou could define a trigger for the tab that selects the maxid every time the user activate s the tab

Wed, 06 Nov 2013 07:30:18 GMT

How is it done exactly?

I defined a trigger on activateSheet -> Select in field action -> Field RUN_ID and variable vMAX_Run:

its still doesnt work, because I removed the condition from the set analysis and the numbers jumped.

I also try to go between Tabs to trigger it but it still didnt work.

did I do something wrong with the syntax?

lironbaram — Wed, 06 Nov 2013 08:38:50 GMT

you in the field box write RUN_ID

in the search string box write =vMax_Run