Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
meetmrudul
Contributor II

Cumulative Volume without Dimension Limit

Hi,

Can we have a Cumulative volume in the the straight table, excluding dimension limit.

Please assist.

Regards,

MK

8 Replies

Re: Cumulative Volume without Dimension Limit

Please elaborate more on the problem with sample data

MVP
MVP

Re: Cumulative Volume without Dimension Limit

It can be done - if you supply a sample qvw file with a data source, and your expected output, you will get more accurate and specific help.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
meetmrudul
Contributor II

Re: Cumulative Volume without Dimension Limit

Hi All,

Please find below, the demo data from the examples of Qlikview, Prescription Tracking.

I have added one column Cumulative current in the straight table and dimension limit as 10.

I want that the, cumulative volume should not consider dimension limit while calculation.

cumulative_vol.png

Please assist.

Regards,

MK

meetmrudul
Contributor II

Re: Cumulative Volume without Dimension Limit

I have replied...

meetmrudul
Contributor II

Re: Cumulative Volume without Dimension Limit

I have replied...

meetmrudul
Contributor II

Re: Cumulative Volume without Dimension Limit

PFA the app

meetmrudul
Contributor II

Re: Cumulative Volume without Dimension Limit

PFA the demo app

meetmrudul
Contributor II

Re: Cumulative Volume without Dimension Limit

PFA the demo app