topic Re: Show Expression as Percentage in QlikView

Show Expression as Percentage

alec1982 — Thu, 02 Aug 2012 22:01:02 GMT

Hi,

I have a pie chart and I want to format the value in the expression as Percentage of total Values.

Anyway I can do that inside of the expression script?

Thxs,

Alec,

Re: Show Expression as Percentage

nagaiank — Thu, 02 Aug 2012 23:36:43 GMT

Just check the 'Relative' checkbox and percentages will be displayed.

Re: Show Expression as Percentage

alec1982 — Thu, 02 Aug 2012 23:53:08 GMT

I cannot use this option as I have a toggle to chnage the expression by user.

The only way I can do is by setting that on the script expression but I don't know how to do that.

Thxs,

Re: Show Expression as Percentage

Anonymous — Thu, 02 Aug 2012 23:57:45 GMT

In this case, try:

num(sum(Value)/sum(total Value), '#,##0%')

Re: Show Expression as Percentage

alec1982 — Fri, 03 Aug 2012 01:38:07 GMT

Hi,

Thanks for the replay .

Logic is correct but the field Value and Total Value are the same field.

I tried:

Num(Sum([Sales])/Sum({1}[Sales]), '#,##0%')

But I got 100% on on all values.

Thxs,

Re: Show Expression as Percentage

Fri, 03 Aug 2012 02:45:28 GMT

Hi,

Michael's expression should work.sum(total sales) forces the sum over all products whereas sum(sales) only computes sales for a particular product.

Regards,

Xue Bin

Re: Show Expression as Percentage

Fri, 03 Aug 2012 02:45:39 GMT

Hi,

Michael's expression should work.sum(total sales) forces the sum over all products whereas sum(sales) only computes sales for a particular product.

Regards,

Xue Bin

Re: Show Expression as Percentage

alec1982 — Fri, 03 Aug 2012 13:24:41 GMT

Thank you guys.

Somehow it wasn't workking yesterday. I t is working as wanted.

Regards,

Alec

Re: Show Expression as Percentage

ioannagr — Mon, 02 Sep 2019 10:26:40 GMT

Same here,

any idea why this is happening?