topic Re: Variable in QlikView

Variable

upaliwije — Thu, 10 Oct 2019 12:14:38 GMT

Hi friends

I have created a variable with the following syntax

vPeriod ={"<=$(=MAX(MONTH))"}

But when I use this variable in below set expression It does not work.

sum({<MONTH={$(vPeriod)>}ACTUAL)

Could you please let me know where I have made the error and let me know how to correct it please.

asinha1991 — Thu, 10 Oct 2019 12:22:24 GMT

try this

vPeriod =MAX( TOTAL MONTH)

sum({<MONTH={"<=$(vPeriod )"}>}ACTUAL)

upaliwije — Thu, 10 Oct 2019 16:33:36 GMT

Thanks for your reply. Here Total month can not be applied since month will be selected depending on the selection in list box

siri4qlik — Thu, 10 Oct 2019 22:31:49 GMT

Try this

You may need to use GetFieldSelections

LET vMaxMonth = '=if(GetFieldSelections(MONTH_FIELD)>0,max(MONTH_FIELD),max(month(today()))-1)';

upaliwije — Fri, 11 Oct 2019 03:28:20 GMT

Thanks

It does not give desired output