topic Set Analysis Expresion Question in QlikView

Set Analysis Expresion Question

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

Hi Experts,

I have a question to ask you.

I’m trying to get percentages on a table so the issue I have is that the calculation must be for a period of 6 months. I have created the variable as vPrevMonth=date(Monthend(date(addmonths(max(APP_MONTH),-5), 'MMM-YY')), 'MMM-YY') to get the 6 months period but I can’t get it right on the pivot table. The pivot is the calculation done for 1 month, I need the same calculation for a 6 month period.

PFA,

Regards

Re: Set Analysis Expresion Question

Anonymous — Tue, 04 Sep 2018 07:59:09 GMT

try this Expression (Need to check the origin values to see if percentage is correct)

=sum({<APP_MONTH={'>=$(=vPrevMonth7)<=$(=max(APP_MONTH))'}>}Count)/sum(total<BA10> {<APP_MONTH={'>=$(=vPrevMonth7)<=$(=max(APP_MONTH))'}>} Count)

Re: Set Analysis Expresion Question

zwyne — Tue, 04 Sep 2018 11:53:34 GMT

Thank you