topic Re: RE: pie chart in QlikView

RE: pie chart

Chanty4u — Mon, 08 Jun 2015 07:36:47 GMT

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

Re: RE: pie chart

ankit777 — Mon, 08 Jun 2015 07:55:51 GMT

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.

Re: RE: pie chart

Chanty4u — Mon, 08 Jun 2015 08:03:17 GMT

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

value 100

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

Thnk you

suresh

Re: RE: pie chart

PrashantSangle — Mon, 08 Jun 2015 08:08:35 GMT

Hi,

Try like

Sum(TOTAL {<Employee=>}Salary)

Sum({<Employee=>}Salary)

Regards

Re: RE: pie chart

ankit777 — Mon, 08 Jun 2015 08:10:01 GMT

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)

Re: RE: pie chart

Chanty4u — Mon, 08 Jun 2015 08:15:59 GMT

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

Re: RE: pie chart

ankit777 — Mon, 08 Jun 2015 08:29:14 GMT

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

Re: RE: pie chart

Chanty4u — Mon, 08 Jun 2015 08:53:52 GMT

hi ankith am nt gettng the chart

i applyied dat expression

result cme lik dis

Re: RE: pie chart

ankit777 — Mon, 08 Jun 2015 09:00:22 GMT

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

Re: RE: pie chart

Chanty4u — Mon, 08 Jun 2015 09:01:29 GMT

thank u ankit.

its wrkng fine..

Thank you suresh

Re: RE: pie chart

ankit777 — Mon, 08 Jun 2015 09:02:57 GMT

cheers...!!!