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: 
CNH_1978
Contributor II
Contributor II

Defining set analysis in a variable and using the variable within the expression

Hi, 

I am defining some set analysis in a variable like below..

vSetAnalysis

MonthYear={' & chr(39) & '$(vSelectedMonthYear)' & chr(39) &'}

I now need to use this variable in the set analysis in the actual expression like below but i can't get it to work..

Sum({<'$(vSetAnalysis)'>}Sales)

Can anyone help to get this to work please?

2 Replies
CNH_1978
Contributor II
Contributor II

Does anyone have any ideas?

NitinK7
Creator III
Creator III

Hi

set variable like

vSet=monthyear

vr.JPG

 

then write below set analysis expression in textbox

=Sum({<Monthyear={"=$(vSet)"}>}sales)

or 

You can use below expression

=sum({<vSet>}sales)