Variable

[upaliwije]

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]

try this

vPeriod =MAX( TOTAL MONTH)

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

[upaliwije]

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

[siri4qlik]

Try this 

You may need to use GetFieldSelections

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

[upaliwije]

Thanks

It does not give desired output