Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

Cud you share sample data?

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

PFA