topic Re: percentage view on pie chart in QlikView

percentage view on pie chart

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

i had a pie chart with percentages

if i click on a slice in the pie chart e.g: 35% , then after clicking on the slice it was becoming 100% how to show 35 % after clicking also

Re: percentage view on pie chart

daanciorea — Wed, 10 Apr 2019 06:23:13 GMT

Hi,

To solve your issue, you only must include your field dimension into set analysis like this:
Count({<[Your dimension]>} Field)
This causes the dimension to be ignored.

I hope I've helped with your issue.
Dan.

Re: percentage view on pie chart

venkat1 — Wed, 10 Apr 2019 06:36:01 GMT

thanks fro the reply ,

i tried but it was not working for me

Re: percentage view on pie chart

daanciorea — Wed, 10 Apr 2019 06:41:21 GMT

Can you attach your expresion?

Re: percentage view on pie chart

venkat1 — Wed, 10 Apr 2019 08:05:28 GMT

Count({<[RM.REGION]>} Capitalize(Lower(RM.REGION)))

Re: percentage view on pie chart

venkat1 — Wed, 10 Apr 2019 08:06:50 GMT

this is my dimension

=Capitalize(Lower(RM.REGION))

and expressions was

fabs((Sum(G.BILL_AMOUNT)+(SUM(Aggr(SUM(DISTINCT D.BILL_AMOUNT),D.VOUCHER_NO,D.LABEL_NO)))))

Re: percentage view on pie chart

jyothish8807 — Wed, 10 Apr 2019 08:20:12 GMT

Hi Venkatesh:

Try like this:

For example your dimension is product and you want to show sales %.

Dim:Product

Exp: sum(Sales)/Sum({1} Sales)

Re: percentage view on pie chart

jyothish8807 — Wed, 10 Apr 2019 08:20:33 GMT

Hi Venkatesh:

Try like this:

For example your dimension is product and you want to show sales %.

Dim:Product

Exp: sum(Sales)/ Sum({1} Sales)