Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE: pie chart

hi need help.

Please find the employee .qvw

and revnenue sheet employee sheet.

the reuirement is

dere are bar chart and pie chart and employee filter

if i select any of employee it wil reflect only in pie chart nt in bar chart

give the suggestions.

thank you suresh

1 Solution

Accepted Solutions
ankit777
Specialist
Specialist

Use the expression I have mentioned above in the pie chart. It fulfills your requirement.

sum(salary)/sum(TOTAL salary)

Also in numbers tab tick Show as percentage

View solution in original post

10 Replies
ankit777
Specialist
Specialist

Hi,

Change your bar chart expression like this.

sum({<Employee=>}salary)

If u select any employee now, u will see change only in pie chart and not bar chart.

Chanty4u
MVP
MVP
Author

tank you ankith its wrkng fyn.

but one more thing i want to disply in pie chart as if v select A in pie chart result vil b

a

value 100

nd % also... means  sum(total)/A like

Thnk you

suresh

PrashantSangle

Hi,

Try like

Sum(TOTAL {<Employee=>}Salary)

/

Sum({<Employee=>}Salary)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ankit777
Specialist
Specialist

Not sure exactly if u want this.

change your pie chart expression like this and let me know if you want this

sum(salary)/sum(TOTAL salary)

Chanty4u
MVP
MVP
Author

pie.JPG

please find the image that vil b the result witout selectng any filter  pie chart wil display % of A and B and C

means A/sum(total).

thanks

suresh

ankit777
Specialist
Specialist

Use the expression I have mentioned above in the pie chart. It fulfills your requirement.

sum(salary)/sum(TOTAL salary)

Also in numbers tab tick Show as percentage

Chanty4u
MVP
MVP
Author

hi ankith am nt gettng the chart

i applyied dat expression

result cme lik dis

pie1.JPG

ankit777
Specialist
Specialist

this is correct. Now go in numbers tab of the pie chart properties and check show as percent(%)

Chanty4u
MVP
MVP
Author

thank u ankit.

its wrkng fine..

Thank you suresh