Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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

View solution in original post

Not applicable

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

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

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?