topic Re: Re: Re: Pie Chart in QlikView

Pie Chart

simsondevadoss — Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I need to display both the percentage and value in the Pie chart as in the screenshot attached.

I have used Sum(Sales)/Sum(TOTAL Sales) to display the percentage. But as per the requirement i need to show the values also.

Is there any possibility to display the Value also?

Regards,

Simson

ecolomer — Sat, 09 Aug 2014 12:09:38 GMT

You can duplicate the expresion ... one with the value and another with the %

maxgro — Sat, 09 Aug 2014 13:10:10 GMT

PFA

Sat, 09 Aug 2014 19:42:00 GMT

Hi Massimo ,

Thanx for share the qvw & it is useful to me .

in the first chart is also , but it is modified as. by number format.

aveeeeeee7en — Sat, 09 Aug 2014 20:34:28 GMT

You need to do little changes in the Edit Script.

Your earlier script was:

SET ThousandSep='.'

SET DecimalSep=','

....

which is giving you the wrong result.

Kindly change it to:

SET ThousandSep=','

SET DecimalSep='.'

....

See the Snapshot:

Also, see the Attachment.

simsondevadoss — Mon, 11 Aug 2014 03:49:45 GMT

Thanks everyone

aveeeeeee7en — Mon, 11 Aug 2014 04:20:47 GMT

Is your issue resolved. Kindly check the attached application and see the used expressions in it.

simsondevadoss — Mon, 11 Aug 2014 05:00:14 GMT

Hi Aviral,

I tried using below expression and it worked.

dual(num(sum(Sales)/sum(total Sales), '#0.0%') & chr(44) & num(sum(Sales),'#0'), sum(Sales))

Regards,

Simson