topic Re: Help with variable within set analysis in QlikView

Help with variable within set analysis

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

Hello,

Example of current set analysis:

=num(sum({$<Lev = {1},PeriodCounter ={">=$(#=max(PeriodCounter)-11<=$(#=max(PeriodCounter))"},period=>}Netsales)*-1/1000000,'# ##0')

I want to store the red part (rolling 12) in a variable. But how do I then use that variable correct? I can't get the right syntax.

Thanks,

Meg

jaibau1993 — Mon, 04 Nov 2019 13:27:10 GMT

Hi!

You should create the variable vSetExpression with the following content

PeriodCounter ={">=$(#=max(PeriodCounter)-11<=$(#=max(PeriodCounter))"},period=

And then you invoque it as follows

=num(sum({$<Lev = {1},$(vSetExpression )>}Netsales)*-1/1000000,'# ##0')

Let me know your doubts! Regards,

Jaime.

Meg00 — Mon, 04 Nov 2019 14:21:15 GMT

Thank you, was more simple than I thought:)