Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

percentage view on pie chart

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

7 Replies
daanciorea
Partner - Contributor III
Partner - Contributor III

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.
venkat1
Creator II
Creator II
Author

thanks fro the reply ,

i tried but it was not working for me

 

daanciorea
Partner - Contributor III
Partner - Contributor III

Can you attach your expresion?
venkat1
Creator II
Creator II
Author


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

venkat1
Creator II
Creator II
Author

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

jyothish8807
Master II
Master II

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)

Best Regards,
KC
jyothish8807
Master II
Master II

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)

Best Regards,
KC