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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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.