Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Having a listbox with measure names

I would love to build a listbox with some measure names.

For instance cost and revenue as two shown options.

When I do this using 'expressions'  (='Revenue') qlikview actually fetches the revenue instances rather than showing revenue as an option.

What I want to do is to show a listbox which - by clicking - determines the measure to be shown in my graph.

1 Solution

Accepted Solutions
Not applicable
Author

Nice issue.

I solved this using an Input Box :

1) defined  a new variable = Measure

2) defined  some variables  Count, Sum, ....   = Count( Value),  Sum(Value)

3)  Create an Input Box with variable Measure displayed

4) go to Constraints panel then check listed value with your variables :  Count; Sum

Then look at the example

JJ

View solution in original post

2 Replies
Not applicable
Author

Nice issue.

I solved this using an Input Box :

1) defined  a new variable = Measure

2) defined  some variables  Count, Sum, ....   = Count( Value),  Sum(Value)

3)  Create an Input Box with variable Measure displayed

4) go to Constraints panel then check listed value with your variables :  Count; Sum

Then look at the example

JJ

Not applicable
Author

My most helpful qlikview lesson till current.

I couldn't open the qvw because i am using the personal version but I found out, also how to base the chart on the chosen measure.

Much thanks