topic Re: Labels / Percentage Errors in QlikView

Labels / Percentage Errors

Thu, 05 Jul 2012 07:31:54 GMT

Hey all,

So basically I've created a the following pie chart with the code within the expressions section (each being a seperate expression)

Good =count({<Q2LastYearScore = {1}, Year = {2011}>} responseid)/ count({<Year = {2011}>} Q2LastYearScore)

Same =count({<Q2LastYearScore = {2}, Year = {2011}>} responseid)/ count({<Year = {2011}>} Q2LastYearScore)

Worse =count({<Q2LastYearScore = {3}, Year = {2011}>} responseid)/ count({<Year = {2011}>} Q2LastYearScore)

and the result i get is :

It shows all the percentages for each section, why is this and how can i change it so it only shows the correct percentage for each section?

Re: Labels / Percentage Errors

Thu, 05 Jul 2012 07:36:07 GMT

Create a calcuated dimension:

if(Q2LastYearScore=1,'Good',if(Q2LastYearScore=2,'Same','Worse'))

and have the expression as

count({<Year = {2011}>} responseid)/ count({<Year = {2011}>} Q2LastYearScore)

You need to have only one expression.

Regards,

Kiran Rokkam.

Re: Labels / Percentage Errors

Thu, 05 Jul 2012 07:47:48 GMT

That gives the following which is not right:

Re: Labels / Percentage Errors

Thu, 05 Jul 2012 08:24:42 GMT

Can you enable "relative" for the expression?

Regards,

Kiran Rokkam.

Re: Labels / Percentage Errors

Thu, 05 Jul 2012 08:32:53 GMT

once enabled still gives incorrect figures 😕

Re: Labels / Percentage Errors

Thu, 05 Jul 2012 08:56:11 GMT

jaivik:

Pie chart shows the contribution of each elements wrt the total. I noticed that expression has a denominator and hence the chart doesnt add up to 1. Can you remove the denominator and disable relative expression. If it doenst work please share a sample for debug.

Kiran Rokkam.