Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help with chart and expression

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

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

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

View solution in original post

3 Replies
Clever_Anjos
Employee
Employee

Go to Presentation Tab

Set Min = 0 and Max = 1

Not applicable
Author

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%).

Clever_Anjos
Employee
Employee

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