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: 
william_fu
Creator II
Creator II

Above() & Before () for two dimensions on pivot table?

Trying to create a measure that divides the current month value by the last month value.

The catch is that I also want the last month value to be offset by one in the dimension I have for banding (Faixas de atraso).

The desired result is a pivot table like below, where each cell is a division of itself by the number one band above and one month prior.

In the highlighted cell, instead of 16, I want it to divide 16 by 36 (# from 2017-Nov's "1-30" band)

I think I need a combination of Above() and/or Before(), but I'm not sure.

pivott.PNG

1 Reply
william_fu
Creator II
Creator II
Author

Nevermind, it works with Above(Before(*measure here*)) in the pivot table..