topic Variables have changed to blank; 2 clicks in QlikView

Variables have changed to blank; 2 clicks

knightwriter — Wed, 01 Jul 2015 16:53:26 GMT

Hi All,

I have created a few different variables and have set them at 0, as of now some variables take a second click of the button to get the variable to 0 which will then allow my table to activate.

My question is, why does it now take to two clicks to activate my table? I have not knowingly changed anything!

Example:

=if(vLw =0,1,0)

Re: Variables have changed to blank; 2 clicks

sunny_talwar — Wed, 01 Jul 2015 17:01:34 GMT

Does this happen everytime you open the application? or is it while development?

May be there is a trigger on open which forces the vLw to be Null() or within the script you have LET vLw = Null();, so every time the app refreshes you end up having vLw as null which needs two click to activate.

Best,

Sunny

Re: Variables have changed to blank; 2 clicks

sunny_talwar — Thu, 02 Jul 2015 13:50:23 GMT

Did you happen to find the root cause of the issue yet?

Re: Variables have changed to blank; 2 clicks

alexandros17 — Thu, 02 Jul 2015 13:56:18 GMT

if your variable is not assigned when your application starts then you first click and assign the first value (not the one that filters) then you click again and it filter. So check the variable value when you open the document.

Verify triggers and eventually set the starting value for the variable in the script

LET myVar =0;

let me know

Re: Variables have changed to blank; 2 clicks

knightwriter — Thu, 02 Jul 2015 14:09:44 GMT

Yes I did actually.I checked the formulas and I had not included the variable formula in all the tables properties.

So originally, when I clicked once the variable when from blank to 0 and by clicking a second time the variable went from 0 to 1 therefore activating the table.

Since Ive included the value in all tables, the variable goes from 0 to 1 in a single click.

Hope that makes sense!

Re: Variables have changed to blank; 2 clicks

jonathandienst — Thu, 02 Jul 2015 14:11:46 GMT

Just change the expression around:

=if(vLw = 1, 0, 1)

When vLw is null, a single click will change it 1 (because 'null = 1' is false).