topic Re: Changing a variable if a specific field value is selected in QlikView

Changing a variable if a specific field value is selected

Tue, 27 Oct 2015 14:11:23 GMT

Hello,

i defined a variable in my document:

showBrain = 0

Now i have an image with the condition that it will only be shown if showBrain = 1.

I now need some kind of trigger or something similar which detects when a specific value in a table is selected.

So for instance i have the table:

Eye

Brain

Stomache

...

Only if the Brain is selected (exclusively meaning no other value in the table) then the variable showBrain is switched to =1.

Eye

Brain

Stomache

...

Also i need a second trigger. Even if the Brain is selected but anything else within the table is selected then the variable should switch back to showBrain =0.

My biggest problem is that i do not exactly know where and how to define this trigger. I guess in the trigger properties for the document?

But i am not sure. Any help is very much appreciated!

Re: Changing a variable if a specific field value is selected

swuehl — Tue, 27 Oct 2015 14:57:49 GMT

I think there are two ways:

1) Create a variable that changes value depending on your conditions, something like

showBrain:

= If( Only( YourFieldName ) = 'Brain', 1,0)

2) Create a field event trigger OnSelect of YourFieldName, with an action to change the variable (with a similar expression like above).

I think I would go for 1), since it's easier to understand what's happening when checking the variable.

Re: Changing a variable if a specific field value is selected

Wed, 28 Oct 2015 10:08:41 GMT

Thank you for that great reply,

i went for your first suggestion and it works great!!!