Discussion board where members can learn more about Qlik Sense App Development and Usage.
May I ask you a pretty (hopefully) simple question.
Let's say I have a model consisting of period and id, like this:
And then, on a new app on a new sheet I want a pivot table with period as a dimension and count of id's for 3 previous periods as a measure: like this as a result
How would one do so?
I don't want it to do in the load editor as this is a simple example, actual values rely on other filtered values, etc.
RangeSum(Above(Count(id), 0, 3))