topic Re: Assign variable inside 'If' statement in QlikView

Assign variable inside 'If' statement

dineshmdane — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have to assign value to a variable inside 'If' statement in an object and not in the script .

Example:

if(second(now())=0,vShow=1,vNext=1)

When I see variable overview the value has not been set for vShow and vNext.

or Please provide some other method to achieve above requirement.

Kindly respond

Regards,

Dinesh M

Re: Assign variable inside 'If' statement

Anonymous — Wed, 23 Nov 2016 09:23:01 GMT

Were are you placing the if statement?

and what do you aim to achieve?

Re: Assign variable inside 'If' statement

jonathandienst — Wed, 23 Nov 2016 09:24:54 GMT

Let vNext = if(second(now())=0, 1, 0);

Let vShow = if(second(now())=0, 1, 0);

Re: Assign variable inside 'If' statement

jonathandienst — Wed, 23 Nov 2016 09:29:29 GMT

But i see you want this in the front end, not in script. Do you want this to be dynamic and continuously calculated? Define them in the script like this:

Set vNext = '=if(second(now())=0, 1, 0)';

Set vShow = '=if(second(now())=0, 1, 0)';

Now the value will continuously update in the front end (providing you are using QV desktop or the IE plugin).

Re: Assign variable inside 'If' statement

dineshmdane — Wed, 23 Nov 2016 10:31:22 GMT

Thanks a lot Jonathan the solution you gave is working .

But the application goes 'not responding' often is there a way to minimize that.

Re: Assign variable inside 'If' statement

jonathandienst — Thu, 24 Nov 2016 06:25:47 GMT

Now() updates at a millisecond rate, and if there are any expressions affected by vNext or vShow, that may cause your application to recalculate. Are either of these variables part of any chart expressions?

Re: Assign variable inside 'If' statement

dineshmdane — Thu, 24 Nov 2016 06:41:50 GMT

No, Jonathan the variable vNext and vShow are not part of any chart.

But, it is a part of variable event trigger which activates sheet when vNext=1 and same for vShow=1.

Thanks & Regards,

Dinesh M