Show value in gauge chart when using if type statement in dimension

[#1]

Hi,

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.

Thanks,

Anne

[kaushiknsolanki]

Hi,

   I would say use the same expression which you have used for guage.

Regards,

Kaushik Solanki    

[IAMDV]

Hi Anne,

If you still having the issue, then please can you post your QV document with some sample data?

Thanks - DV

[#4 · Accepted solution]

Hi,

I managed to work it out.

=count(IF(CUR_LOS>MyLOS,stay_number))/count(stay_number)*100

Thanks.

Anne

>>> qliktech@sgaur.hosted.jivesoftware.com 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:

http://community.qlik.com/message/132055#132055