Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two calculations one previous month

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

3 Replies
Not applicable
Author

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?

mangalsk
Creator III
Creator III

hello,

Please attach sample qvw

Not applicable
Author

See attached qvw.