Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a gauge chart where the dimension is an if type statement (=FieldName>Variable) and the expression is a count (Count(FieldName2)).
The gauge works fine, but I can't figure out how to build the 'Text in Chart' expression to show the calculated value as a number (%) on the gauge.
I tried IF(CUR_LOS>MyLOS,count(stay_number))/count(stay_number)*100 but I just get a dash.
I would appreciate any assistance.
Go to Solution.
I managed to work it out.
>>> firstname.lastname@example.org 12/07/2011 06:53 pm >>>
D V created the discussion
"Re: Show value in gauge chart when using if type statement in dimension"
To view the discussion, visit:
I would say use the same expression which you have used for guage.
If you still having the issue, then please can you post your QV document with some sample data?
Thanks - DV