Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I want show the data for last 12 months for each month.
For example I have a columns like "Month-Year" and "Value" like below table, and for Jan-2018 it needs to show the sum of last 12 months(means Feb-2017 to Jan-2018) values, like this for all months need to show the some of last 12 months from that month.
Month-Year | Value | sum of value for last 12 months for each month |
Jan-2018 | 10 | |
Feb-2018 | 30 | |
Mar-2018 | 50 | |
Apr-2018 | 100 | |
May-2018 | 200 | |
Jun-2018 | 40 | |
Jul-2018 | 50 | |
Aug-2018 | 60 | |
Sep-2018 | 75 | |
Oct-2018 | 96 | |
Nov-2018 | 77 | |
Dec-2018 | 45 | |
Jan-2019 | 98 | |
Feb-2019 | 78 | |
Mar-2019 | 65 | |
Apr-2019 | 90 | |
May-2019 | 80 | |
Jun-2019 | 77 | |
Jul-2019 | 67 | |
Aug-2019 | 56 | |
Sep-2019 | 98 | |
Oct-2019 | 23 | |
Nov-2019 | 43 | |
Dec-2019 | 55 |
If either of the existing posts helped you with your use case, be sure to return to the thread and use the Accept as Solution button on the one(s) that did help. This gives the posters credit for the assistance and lets other Community Members know what actually worked for you.
The only thing I have in addition to what they posted is a specific Design Blog post that may help with this use case, and then I am including the base URL to the area too in case you wish to further search for things yourself:
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett
RangeSum(Above(Value,0,12))
or this
RangeSum(Above(TOTAL Value,0,12))
if you want to calculate it via script flag method. follow below post
https://community.qlik.com/t5/QlikView-Documents/Rolling-N-months/ta-p/1484325
If either of the existing posts helped you with your use case, be sure to return to the thread and use the Accept as Solution button on the one(s) that did help. This gives the posters credit for the assistance and lets other Community Members know what actually worked for you.
The only thing I have in addition to what they posted is a specific Design Blog post that may help with this use case, and then I am including the base URL to the area too in case you wish to further search for things yourself:
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett