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: 
Anonymous
Not applicable

How to display expression in Text object as percentage?

I have a set analysis expression that I need to display as a percentage, can anyone help?

Expression: = (count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}[Delivered Quantity]))

This expression is used as 'Text in chart' on a gauge chart FYI.

Thank you

1 Solution

Accepted Solutions
sunny_talwar

How about this

Num(Count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>} [Delivered Quantity])/Count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late'}>} [Delivered Quantity]), '#0.0%')

View solution in original post

9 Replies
shiveshsingh
Master
Master

May be like this

Num( count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}[Delivered Quantity]), '#,##0%')

Anonymous
Not applicable
Author

Did not work unfortunately

jyothish8807
Master II
Master II

Try Like this:

num(

(count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}[Delivered Quantity])) 

/

(count({1<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}total [Delivered Quantity])),'##.0%')

Best Regards,
KC
Anonymous
Not applicable
Author

Hi Jyothish,

Thank you the expression has been accepted as suitable however the percetnage value shown is different to the one shown from the original expression shown in my first post.

Any ideas?

Anonymous
Not applicable
Author

Hi Alexander,

Try this,

=Num(((count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>}[Delivered Quantity]))/

(count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late' }>}[Delivered Quantity]))),'##0.00%')

hopefully this will work.

sunny_talwar

How about this

Num(Count({$<[Performance (Requested Date)] = {'Early' , 'On Time'}>} [Delivered Quantity])/Count({$<[Performance (Requested Date)] = {'Early' , 'On Time', 'Late','Undelivered Late'}>} [Delivered Quantity]), '#0.0%')

Anonymous
Not applicable
Author

Thank you Sunny and everyone else this has worked

Cheers,

Alex.

shiveshsingh
Master
Master

Missed the formatting

Thanks buddy

jyothish8807
Master II
Master II

It was my mistake, i did not say the "/" in your expression and thought this as a complete one count. So i divided the same expression with the total

Br,

KC

Best Regards,
KC