Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alexbg1997
Contributor III
Contributor III

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

alexbg1997
Contributor III
Contributor III
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
alexbg1997
Contributor III
Contributor III
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?

yogesharekar
Contributor III
Contributor III

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

alexbg1997
Contributor III
Contributor III
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