Qlik Community

App Development

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
_k0zm0_2
Contributor III
Contributor III

Cumulative value in the first element of a dimension

Hello Experts,

I'm trying to display some data for rolling 12 months, and the first month must include the value of its rolling 12 but I can't figure how to get it.

Sample data:

Sales:

LOAD * INLINE [

    Month, Year, Sales, R12

    07, 15, 98127, 0

    08, 15, 70834, 0

    09, 15, 102456, 0

    10, 15, 92151, 0

    11, 15, 25420, 0

    12, 15, 15125, 0

    01, 16, 73453, 0

    02, 16, 23623, 0

    03, 16, 49325, 0

    04, 16, 696821, 0

    05, 16, 59686, 0

    06, 16, 268762, 0

    07, 16, 798165, 1

    08, 16, 8721312, 1

    09, 16, 546848, 1

    10, 16, 54231, 1

    11, 16, 218723, 1

    12, 16, 216787, 1

    01, 17, 363135, 1

    02, 17, 73781, 1

    03, 17, 845945, 1

    04, 17, 842907, 1

    05, 17, 953567, 1

    06, 17, 935689, 1

];

R12 is the flag of Rolling 12

So, I get these data

screenshot_1.png

But when I select the rolling 12 Months:

screenshot_2.png

Is there any way to get that the value of 07.16 could be 2.275.821?

Thanks in advance.

PS: I'm using Qlik Sense Desktop 3.2 SR4

1 Solution

Accepted Solutions
sunny_talwar

Which field are you making selection in? Month.Year or is it some other month and year field? You have to ignore selection in that field

RangeSum(Above(Sum({<Month.Year>} Sales), 0, 12)) * Avg(1)

View solution in original post

6 Replies
kaushiknsolanki

Hi,

I feel you should do this in script instead of in chart. Then you will get what you want.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
_k0zm0_2
Contributor III
Contributor III
Author

Thanks for que quick reply. Unfortunately, there is some filters in the sheet (customer, products...), so it should be done in chart.

sunny_talwar

Try this

RangeSum(Above(Sum({<Month.Year>} Sales), 0, 12)) * Avg(1)

_k0zm0_2
Contributor III
Contributor III
Author

Thanks for your answer Sunny, I get the same values

screenshot_3.png

sunny_talwar

Which field are you making selection in? Month.Year or is it some other month and year field? You have to ignore selection in that field

RangeSum(Above(Sum({<Month.Year>} Sales), 0, 12)) * Avg(1)

_k0zm0_2
Contributor III
Contributor III
Author

Thank you very much, Sunny.

RangeSum(Above(Sum({<Month.Year, R12>} Sales), 0, 12)) * Avg(1)

And supress zero values did the trick!