Solved: Re: Re: Pie Chart - Qlik Community

simsondevadoss · ‎2014-08-09

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

maxgro · ‎2014-08-09

PFA

ecolomer · ‎2014-08-09

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

maxgro · ‎2014-08-09

PFA

Report Inappropriate Content · ‎2014-08-09

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 · ‎2014-08-09

Hi

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 · ‎2014-08-10

Thanks everyone

aveeeeeee7en · ‎2014-08-11

Hi

i

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

simsondevadoss · ‎2014-08-11

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