topic IF expression with variable isn't working as expected in QlikView

IF expression with variable isn't working as expected

lprasanth — Sat, 16 Nov 2024 04:33:26 GMT

if(encours_date_forescast='$(vpop1)',encours_qte_forescast ) as newone1, and the variable value is

LET vpop1 ='=only({<idDateStkP={1}>}[date stock projection])';

when i use newone1 in the chart expression, the value isn't coming as expected. chart expression is given below

aggr(sum(newone1 * $(vfilter5)))

can you guys help to find a solution on this one

Re: IF expression with variable isn't working as expected

pradosh_thakur — Tue, 05 Feb 2019 12:56:47 GMT

not sure you can use set analysis in such a way in script.

Re: IF expression with variable isn't working as expected

sunny_talwar — Tue, 05 Feb 2019 13:04:13 GMT

There are multiple moving parts in your example... are you able to share a sample to show what you have and trying to achieve? May be there is a better way to program this

Re: IF expression with variable isn't working as expected

dplr-rn — Tue, 05 Feb 2019 13:54:56 GMT

Set analysis cannot be used in script.
as sunny says not knowing your scenario difficult to help properly
but on face value, i would say you will need to use peek function (and possibly some sort of resident load with a where condition idDateStkP=1 ) to load the variable