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

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

Tue, 12 Jul 2011 06:07:16 GMT

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 — Tue, 12 Jul 2011 06:15:31 GMT

Hi,

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

Regards,

Kaushik Solanki

IAMDV — Tue, 12 Jul 2011 08:53:13 GMT

Hi Anne,

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

Thanks - DV

Tue, 12 Jul 2011 23:04:25 GMT

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