Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Multiple Gauges from one List box

If anyone knows if this is possible, I would appreciate your help.

I have a list box which looks like this

StepNumber, StepName, Qty

1,Name1,5

2,Name2,3

3,Name3,7

etc

I would like to create a seperate gauge for each step, so that gauge1 = 5, guage2 = 3, guage3 = 7 etc.

If I setup my used dimensions as

=Count ({<StepNumber=1>} DocumentStatus)

and then select a record from the list box, the gauge displays the Qty correctly.

However, I dont want to select any records in the list box, but if I dont select anything, it just displays a total count. 

I can add a calculation condition of StepNumber=1, however then I get a "Calculation condition unfulfilled" on the chart if I dont select record 1.

Finally, is it then possible to set the title of the gauge to dynamically pick up the StepName?

Thanks

1 Solution

Accepted Solutions
Not applicable

Multiple Gauges from one List box

I managed to work out how to do this.

On the "Expressions" Tab, in the definition field, I changed the expression from

=count(DocumentStatus)   -----> this is my QTY

to

=count ({$<StepNumber={1}>} DocumentStatus)

and repeated it for each of my steps.

3 Replies
nagaiank
Valued Contributor III

Re: Multiple Gauges from one List box

You can have one listbox for the three fields. Selecting one entry can be made to select three fields using event triggers.

So if you select line '1,Name1,5', it is equivalent to selecting '1' in the listbox for StepNumber, 'Name1' in the listbox for StepName and '3' in the listbox for 'Qty'.

From this you can have gauges with conditional calculations.

A sample qvw file is attached for your reference.

Hope this helps.

Not applicable

Re: Multiple Gauges from one List box

Thank you but I already have the list box with the three fields and I do NOT want to select any lines from it.

Also, thanks for your example, however I currently only have the personal edition and cannot open it.

Not applicable

Multiple Gauges from one List box

I managed to work out how to do this.

On the "Expressions" Tab, in the definition field, I changed the expression from

=count(DocumentStatus)   -----> this is my QTY

to

=count ({$<StepNumber={1}>} DocumentStatus)

and repeated it for each of my steps.

Community Browser