Trigger to set variable to null

Tue, 09 Apr 2013 14:05:48 GMT

Hi All,

I'm using input boxes and variables to allow users to put in lower and upper limits for a selection. The triggers are working for this selection (<= and >=) so that only values between what they have entered are selected.

Now, when they clear all selections obviously the seleciton created by those variables is cleared but unfortunately the values they have input in the input boxes remain - so some people may get confused in this situation as to why there are values when they've cleared the selection.

I have tried putting a trigger on the clear selections button to set the variable to ='', but this doesn't work.

Does anyone know how I set up a trigger to make a number variable = null or blank? I have tried putting:

=null()

this works for a variable with no constraints but not for one that must be a number.

Thanks in advance.

GPC

Re: Trigger to set variable to null

Gysbert_Wassenaar — Wed, 10 Apr 2013 12:57:42 GMT

In the Set Variable action simpy leave the Value value empty. The action will then empty the variable.

Re: Trigger to set variable to null

Wed, 10 Apr 2013 15:36:56 GMT

Hi Gysbert,

Thanks for your reply, however that doesn't seem to work for me unfortunately... I left it blank but it doesn't empty the variable.

Thanks

GPC

topic Re: Trigger to set variable to null in QlikView

Trigger to set variable to null

Re: Trigger to set variable to null

Re: Trigger to set variable to null