topic Re: Re: Two calculations one previous month in QlikView

Two calculations one previous month

Mon, 24 Nov 2014 07:37:35 GMT

Hi all.

My question is maybe that difficult but I doesn't find any good solution.

I have a calculation like this:

sum(aggr((sum({<Salary_Type_ID={'020'}>} Num_Hours_Def))

*(Max({$<KPI_Heading={"Contracted Hours Per FTE"}, KPI_RowDesc={"Draketimmar"}>} KPI_Value)))

if(Staff_Category_ID='Staff', (Max({$<KPI_Heading={"Contracted Hours Per FTE"}, KPI_RowDesc={"SPX"}>} KPI_Value)),

(Max({$<KPI_Heading={"Contracted Hours Per FTE"}, KPI_RowDesc={"Draketimmar"}>} KPI_Value)))))),Business_Group_ID ,Business_Unit_ID, Staff_Category_ID, Agreement_ID, Booking_month))

On the second calculation (the if statement) I would like to compare with the previous month.

Thanks in advance

Re: Two calculations one previous month

Thu, 27 Nov 2014 07:19:29 GMT

I will try to make it more clear.

First expression: jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec

Second expression: feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec, jan

Any one that have a godd solution for this?

Re: Two calculations one previous month

mangalsk — Thu, 27 Nov 2014 07:27:09 GMT

hello,

Please attach sample qvw

Re: Re: Two calculations one previous month

Thu, 27 Nov 2014 08:25:18 GMT

See attached qvw.