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, 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]

May be this

Count({<Month>}Material)

[#3]

Thx Sunny,

But I would like to show just selected month in the chart (from jan to march 2017 in my case).

I got the message about duplicated threads.

Ricky.

[sunny_talwar · Accepted solution]

May be this

RangeSum(Above(Count({<Month>}Material), 0, RowNo())) * Avg(1)

[#5]

Thx a lot Sunny,

Can you just tell me how to hide ther moths in the chart (when I try your solution, I m still seeing the other months (before 2017) with 0 value).

Ricky.

[sunny_talwar]

Can you show the image of what you are seeing?

[#7]

Here you are:

[sunny_talwar]

Can you check if you have unchecked 'Suppress Zero Values' on the presentation tab? Make sure it is checked

[#9]

Yes, I have checked both options (checked and unchecked), the resul was same.

[sunny_talwar]

What version of QlikView are you using? This might be a version related issue? Did you try to open the app I attached and you saw the same issue?