Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cycle through measures (cases, bottles, units etc..)

Hello,

I'm in the beverage business and we look at our volume of products in many different ways. This includes

Litres, units, cases, 9L cases etc...

Right now when I create a report/chart on qlikview, i have to list out all the measures and it's too overwheming for our users. I want the ability to select from list that have litres, units, cases, 9l cases etc... and when i select this, the numbers on the report will change to the measure that i selected. There is a simple conversion/math that i apply to switch from each of the measures.

Does anybody know how to do this?

A qlikview support rep suggested that I uses variables but I'm not familiar enough with the technology to know where to start.

2 Replies
michael_anthony
Creator II
Creator II

Mike, Another way is to use Grouped Expressions. Create your list of all measures as you already have. Select the second expression and click the Group button (underneath expression list). Do same for all measures.

On your chart you'll now have a Cycle button that can cycle through each measure. I'm assuming that each measure you have does the conversion for all relevant rows.

Not applicable
Author

Great idea. Thanks!