Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Variable

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.

4 Replies
asinha1991
Creator III
Creator III

try this

vPeriod =MAX( TOTAL MONTH)

 

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

upaliwije
Creator II
Creator II

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

siri4qlik
Contributor
Contributor

Try this 

You may need to use GetFieldSelections

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

upaliwije
Creator II
Creator II

Thanks

It does not give desired output