Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

supportlahaye
New Contributor

Set Analysis - Measure sliding month from a dimension of the table

Hello,


I want to perform a setAnalysis that would be able to recover 3 months sliding (current month + 2 months previous) of a measurement according to the period dimensioned in the table.


Example: In the example below, here are the CAs for each calendar period:

Imagine the following data:

Period   :  CA          :  CA 3 Months Slippery

201803 :  14 280  :  96,081

201802 :  37,634  :  91,801

201801 :  44 167  :  59,167

201712 :  10,000  :  etc ...

201711 :    5,000

Capture.PNG

CA measurement: sum (ca)

CA Measurement 3 Months Slippery:?


Thank you in advance for your help !

Tags (1)
3 Replies
Digvijay_Singh
Honored Contributor III

Re: Set Analysis - Measure sliding month from a dimension of the table

Maybe this -

Rangesum(Below(Sum(CA),0,3))

Capture.PNG

supportlahaye
New Contributor

Re: Set Analysis - Measure sliding month from a dimension of the table

It Works !

I use the Rangeavg in my case in the end.

Thank You so much !

Highlighted
Digvijay_Singh
Honored Contributor III

Re: Set Analysis - Measure sliding month from a dimension of the table

Great! You may close this thread by marking correct answer.

Community Browser