topic How to change the UI variable to Script variable? in QlikView

How to change the UI variable to Script variable?

Tue, 22 Nov 2016 02:28:26 GMT

Hi Folks,

I have variable called vCrAmt, it is declared in UI side i.e., Settings>Variable Overview.

Now i am trying to call the same variable from Edit Script.

SET vCrAmt=SUM({$<[Trxn. Date]={"$(=DATE(MAX[Trxn. Date]))"}>}CrAmt);

Can anyone help me to put the same in Edit Script....

I tried like this...

SET vCrAmt='SUM({$<[Trxn. Date]={"$(=DATE(MAX[Trxn. Date]))"}>}CrAmt)';

getting no value..

Thanks in advance...

sushil353 — Tue, 22 Nov 2016 03:18:28 GMT

Try this:

SET vCrAmt= '=SUM({$<[Trxn. Date]={"$(=DATE(MAX[Trxn. Date]))"}>}CrAmt)';

Tue, 22 Nov 2016 05:35:09 GMT

i will try and let u know

Thanks for the reply Sushil Kumar

Tue, 22 Nov 2016 05:38:25 GMT

Hi Sushil,

I am trying like this, its not working..

SET vCrAmt='=Sum({$<[Trxn. Date]={"$(=DATE(MAX([Trxn. Date])))"}>}[CrAmt])';

sushil353 — Tue, 22 Nov 2016 06:21:57 GMT

this must work..

how are you using this variable in your expression..? have u checked the same expression in text box?

Tue, 22 Nov 2016 06:57:14 GMT

Yes Sushil,

Its showing this

'=Sum({$<[Trxn. Date]={"$(=DATE(MAX([Trxn. Date])))"}>}[CrAmt])' --> Text Object Expr