topic Help: My straight table sum is not accurate!!! in QlikView

Help: My straight table sum is not accurate!!!

Thu, 04 Apr 2013 17:28:30 GMT

Here is where my definition is-------------------------> here is my count and the bolded number is the sum.... clearly, 2+3+2+3+1+1 =/= 8...

can someone please tell me where i made the mistake at please?

also, i am trying to do:

sum(count(distinct DeliveryPostalCode)) and i kept getting the wrong answer, does anybody have any insight on this??

Re: Help: My straight table sum is not accurate!!!

Anonymous — Fri, 05 Apr 2013 01:29:47 GMT

Hi Jim,

If you have a straight table, you can just go to the chart properties > expression tab > set expression total to "Sum of rows" instead of expression default.

Re: Help: My straight table sum is not accurate!!!

kaushiknsolanki — Fri, 05 Apr 2013 06:06:25 GMT

Hi,

If the solution given by Johannes doesnt work try this.

Sum(Aggr(Count (Distinct DeliveryPostalCode),Dimension1,Diemsnsion2))

Change the Dimension1 with tour dimensions of the chart. Include all the dimension seperated by comma.

Regards,

Kaushik Solanki

Re: Help: My straight table sum is not accurate!!!

hic — Fri, 05 Apr 2013 06:25:14 GMT

Both Johannes' and Kaushik's solutions will change the number so you get 12 instead of 8.

But be careful here. I would first check my data: If QlikView says "8" on the total row, then there are only 8 distinct values in the data set. QlikView does not return the wrong answer. The reason that you have the numbers you have, is that your data model is made so that one and the same distinct value is found on several rows in the straight table. So if you sum it to 12, you will count the same value twice. If that is the way you want it, then you should use Johannes' or Kaushik's solution.

But if it isn't, you should think again.

HIC

Re: Help: My straight table sum is not accurate!!!

Fri, 05 Apr 2013 12:43:56 GMT

Mr. Johannes Sunden,

thank you for your answer, that's exactly what i need.

Re: Help: My straight table sum is not accurate!!!

Fri, 05 Apr 2013 12:44:25 GMT

Mr Kaushik Solanki,

thank you for your input, it's more than helpful!!!

Re: Help: My straight table sum is not accurate!!!

Fri, 05 Apr 2013 12:45:49 GMT

Mr Henric Cronstrom,

thank you for your input, double counting the numbers is exactly what i need, thank you!