topic Re: Set Analysis with Variable in QlikView

Set Analysis with Variable

Anonymous — Fri, 06 Nov 2015 14:06:38 GMT

I have created a variable to determine the previous month (PreviousMonth).

I can create a chart using the variable, but I want to do this as set analysis in the chart.

Please can anyone help me with the code. My current expression is :

If(

MonthName(Date(Month_Yr))=MonthName(Date(PreviousMonth-1)),

(Sum({<Sick_Type={'STS'}>} ((Absence_FTE)))/Sum({<Sick_Type={'STS'}>} ((Avail_FTE))))+

(Sum({<Sick_Type={'LTS'}>} ((Absence_FTE)))/Sum({<Sick_Type={'LTS'}>} ((Avail_FTE))))

)

Any help appreciated?

Regards

Phil

Re: Set Analysis with Variable

lironbaram — Fri, 06 Nov 2015 14:11:33 GMT

you can't use expressions in set analysis in the left side of the equation

so if you want to use monthname you'll need to create a field with this data in your script

but maybe this will work

(Sum({<Sick_Type={'STS'},Month_Yr={"$(=(PreviousMonth)-1)"}>} ((Absence_FTE)))/Sum({<Sick_Type={'STS'},Month_Yr={"$(=(PreviousMonth)-1)>} ((Avail_FTE))))+

(Sum({<Sick_Type={'LTS'},Month_Yr={"$(=(PreviousMonth)-1)>} ((Absence_FTE)))/Sum({<Sick_Type={'LTS'},Month_Yr={"$(=(PreviousMonth)-1)>} ((Avail_FTE))))

Re: Set Analysis with Variable

Anonymous — Fri, 06 Nov 2015 14:22:17 GMT

A couple of typo's, but it still didn't work. Tried ....

(Sum({<Sick_Type={'STS'},Month_Yr={'$(=(PreviousMonth)-1)'}>} ((Absence_FTE)))/Sum({<Sick_Type={'STS'},Month_Yr={'$(=(PreviousMonth)-1)'>} ((Avail_FTE))))

(Sum({<Sick_Type={'LTS'},Month_Yr={'$(=(PreviousMonth)-1)'}>} ((Absence_FTE)))/Sum({<Sick_Type={'LTS'},Month_Yr={'$(=(PreviousMonth)-1)'>} ((Avail_FTE))))