topic Multiple Gauges from one List box in QlikView

Multiple Gauges from one List box

Wed, 22 Jun 2011 01:20:31 GMT

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

Re: Multiple Gauges from one List box

nagaiank — Wed, 22 Jun 2011 02:26:08 GMT

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.

Re: Multiple Gauges from one List box

Wed, 22 Jun 2011 02:33:14 GMT

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.

Multiple Gauges from one List box

Fri, 24 Jun 2011 05:07:17 GMT

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

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

and repeated it for each of my steps.