Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
meetmrudul
Contributor II

cumulative volume

Hi All,

We have a requirement, where we need to calculate the cumulative volume in the straight table.

We also have a Top N functionality for the chart.

We have set Full accumulation as 'Yes' in the Expressions Tab, and it works fine.

Now, the requirement has changed and they want that the cumulative volume should not consider Dimension Limit.

And other expressions should consider the same.

Any suggestion on that.

Please suggest.

Thanks & Regards,

MK

3 Replies
balrajahlawat
Esteemed Contributor

Re: cumulative volume

Cud you share sample data?

meetmrudul
Contributor II

Re: cumulative volume

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.

Please Assist.

thanks & Regards,

MK

meetmrudul
Contributor II

Re: cumulative volume

PFA