topic Re: Expression calculation for PIE chart is wrong in QlikView

Expression calculation for PIE chart is wrong

amber2000 — Tue, 09 Sep 2014 16:30:34 GMT

Hello Boys and Girls,

I'm having a problem with an expression.

In my table most of the fields are expressions with subtotals on top and the calculations are correct.

However if I make a PIE chart from the data something is going wrong, I want to have a total value of 100% in the pie.

It's a rather difficult calculation and I've tried many options but nothing I do gives me the correct values.

As a result I want the value of each record from field #Absolute divided by the subtotal of that field.

I'm attaching a small example so It's easyer to understand what I'm trying to do, The Column "TEST_Juist_Waardes" are manualy fixed by myself and it's these results I want to see in the Pie.

Is this even possible?

Kind regards,

Monique

Re: Expression calculation for PIE chart is wrong

m_woolf — Tue, 09 Sep 2014 16:42:33 GMT

Try taking out the "/100" from your expression and then check the Relative box

Re: Expression calculation for PIE chart is wrong

jerem1234 — Tue, 09 Sep 2014 16:43:30 GMT

Hi Amber,

I used the formula:

sum([#Absolute])/ Sum(total #Absolute)

Please find attached as well.

Hope this helps!

Re: Expression calculation for PIE chart is wrong

MK_QSL — Tue, 09 Sep 2014 16:45:39 GMT

Use below expression

NUM(sum({$<[ReasonCode_Desc]={"*"}>} [#Absolute])/sum(TOTAL {$<[ReasonCode_Desc]={"*"}>} [#Absolute]),'#.##0.00%')