Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

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

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

3 Replies

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

Hi,

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

Regards,

Kaushik Solanki    

IAMDV
Honored Contributor II

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

Hi Anne,

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

Thanks - DV

Not applicable

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

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

Community Browser