topic Re: cumulative volume in QlikView

cumulative volume

Anonymous — Thu, 24 Sep 2015 11:13:41 GMT

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,

Anonymous — Thu, 24 Sep 2015 11:19:28 GMT

Cud you share sample data?

Anonymous — Thu, 24 Sep 2015 11:32:42 GMT

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,

Anonymous — Thu, 24 Sep 2015 11:33:54 GMT

PFA