topic Re: How to conditionaly change variables in QlikView

How to conditionaly change variables

mwscott1 — Wed, 12 Aug 2015 13:21:55 GMT

I have a variable for my workgroups "vWrkGrps". This variable contains 9 workgroups (WG1, WG2, WG3, WG4, WG5, WG6, WG7, WG8, WG9). What I would like to do is when my dashboard opens the variable would only contain WG1-WG8. Then with some sort of on/off filter button I could add in WG9 to the variable when needed.

Basically we have a new workgroup that we do not want calculated into our metrics for reporting, but would still like to periodically include them to see how things are progressing.

Re: How to conditionaly change variables

Clever_Anjos — Wed, 12 Aug 2015 13:25:15 GMT

Are you writing about a variable or a field?

Re: How to conditionaly change variables

maximiliano_vel — Wed, 12 Aug 2015 13:30:10 GMT

Create a new variable say vAllGroups=1

In Actions of the button you could add an action->external->set variable

In Variable: vWrkGrps

In Value: =if(vAllGroups=1, 'WG1, WG2, WG3, WG4, WG5, WG6, WG7, WG8', 'WG1, WG2, WG3, WG4, WG5, WG6, WG7, WG8, WG9')

Other Action in Same button

In Variable: vAllGroups

In Value: =if(vAllGroups=1, 0, 1)

Re: How to conditionaly change variables

mwscott1 — Wed, 12 Aug 2015 13:32:26 GMT

A variable. I use the "vWrkGrps" variable in my calculations and was trying to figure out a way to take out WG9 conditionally. I can go in and manually remove the WG9 from my variable to get the reports with and with out WG9 included. Just wondering if there was a way the end user could do this through the presentation with a filter button or something.

Re: How to conditionaly change variables

jonathandienst — Wed, 12 Aug 2015 13:34:41 GMT

Rather than using events and buttons and actions, why not save a bookmark with all the workgroups and one that excludes WG9?