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

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

CNH_1978 — Wed, 25 Nov 2020 16:16:04 GMT

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?

CNH_1978 — Sat, 22 Feb 2020 10:14:33 GMT

Does anyone have any ideas?

NitinK7 — Sat, 22 Feb 2020 18:58:19 GMT

set variable like

vSet=monthyear

then write below set analysis expression in textbox

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

You can use below expression

=sum({<vSet>}sales)