Multiple Gauges from one List box

[#1]

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

[nagaiank]

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.

[#3]

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.

[#4 · Accepted solution]

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.