topic help with chart and expression in QlikView

help with chart and expression

Wed, 07 Oct 2015 12:22:44 GMT

Hi,

We have a app (attached) which is recording a log of work my team does. We have the following expression on a pie chart which works fine (number tally up).

({<[Inform business decisions?]= {'Yes'}>} [Inform business decisions?])/Count(TOTAL [Inform business decisions?)

However, for a gauge chart (next to it) it won't work. There is 693 records and 37 that have informed business decisions so % is 6.2%.

Can anyone advise on what the expression and settings will be on the gauge chart so it works? Also can you please advise on the expression in 'text in chart' so the 6.23% show correctly (currently 0.6228956228)..my current expression was this and it doesn't work:

Num(Count({<[Inform business decisions?] = {'Yes'}>} [Inform business decisions?]), '#.##0%')

Chris

Re: help with chart and expression

Clever_Anjos — Wed, 07 Oct 2015 12:28:13 GMT

Go to Presentation Tab

Set Min = 0 and Max = 1

Re: help with chart and expression

Wed, 07 Oct 2015 13:07:55 GMT

Hi,

Cheers - that has fixed gauge in that % is showing on the bar, but this doesnt fix 'text in chart' expression or why the top end of the scale isn't showing (100%).

Re: help with chart and expression

Clever_Anjos — Wed, 07 Oct 2015 14:29:55 GMT

Text in char :

=num(Count({<[Inform business decisions?]= {'Yes'}>} [Inform business decisions?])/Count(TOTAL [Inform business decisions?]),'#,##0.00%')

100%, change to 6 Major units