Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative count (out of selection) in qlikview chart expression

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.

1 Solution

Accepted Solutions
sunny_talwar

May be this

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

Capture.PNG

View solution in original post

18 Replies
sunny_talwar

May be this

Count({<Month>}Material)


Capture.PNG

Not applicable
Author

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

May be this

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

Capture.PNG

Not applicable
Author

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?

Not applicable
Author

Here you are:

sunny_talwar

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

Not applicable
Author

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?