Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
Champion III
Champion III

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
Champion III
Champion III
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.
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
Champion III
Champion III
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

View solution in original post

Chanty4u
Champion III
Champion III
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
Champion III
Champion III
Author

thank u ankit.

its wrkng fine..

Thank you suresh