Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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..