Cumulative count (out of selection) in qlikview chart expression

[#1]

Hello,

I would like to count materials from the beginning (January 2010) even if I select ONLY year 2017.

In other words, if I select ONLY 2017’s month for my chart, I would like to have:

- For January 2017: Cumulative Count of materials From January 2010 To  January 2017.

- For February 2017: Cumulative Count of materials From January 2010 To  February 2017.

- For March 2017: Cumulative Count of materials From January 2010 To  March 2017.

PFA file for more details.

Thx in advance for your help.

Ricky.

[sunny_talwar]

Please check the response here:

Cumulative count (out of selection) in qlikview chart expression

and try not to create duplicate threads

[Sergey_Shuklin · Accepted solution]

Hello, Ricky!

For getting the value of selected date you can use this set analysis expression:

Count({<Month={"<=$(#=max(Month))"}>}Material)

This "$(#=max(Month))" will calculate the maximum of dates, and this "<=" will take only those which a lower or equal of max.

After that you can take a different steps for solving the task.

The first - use the "Accumulate" option on expression tab in the chart.

The second - use the rangesum function:

rangesum(Above(Count({<Month={"<=$(#=max(Month))"}>}Material),0,RowNo()))

Both of them will bring you to the result you needed.

Please, find the attachement and look at the screenshot below:

Is this what you want to achieve?

[#4]

Thx Sergey,

It's OK for me.

Ricky.