topic Re: How to display expression in Text object as percentage? in QlikView

How to display expression in Text object as percentage?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to display expression in Text object as percentage?

shiveshsingh — Thu, 24 May 2018 10:40:40 GMT

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

Re: How to display expression in Text object as percentage?

Anonymous — Thu, 24 May 2018 10:43:19 GMT

Did not work unfortunately

Re: How to display expression in Text object as percentage?

jyothish8807 — Thu, 24 May 2018 10:43:22 GMT

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

Re: How to display expression in Text object as percentage?

Anonymous — Thu, 24 May 2018 10:51:12 GMT

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?

Re: How to display expression in Text object as percentage?

Anonymous — Thu, 24 May 2018 11:08:51 GMT

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.

Re: How to display expression in Text object as percentage?

sunny_talwar — Thu, 24 May 2018 11:17:43 GMT

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

Re: How to display expression in Text object as percentage?

Anonymous — Thu, 24 May 2018 11:23:16 GMT

Thank you Sunny and everyone else this has worked

Cheers,

Alex.

Re: How to display expression in Text object as percentage?

shiveshsingh — Thu, 24 May 2018 11:26:24 GMT

Missed the formatting

Thanks buddy

Re: How to display expression in Text object as percentage?

jyothish8807 — Thu, 24 May 2018 11:41:53 GMT

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,