topic double values of sum function in QlikView

double values of sum function

Fri, 18 May 2012 08:35:51 GMT

hi all,

i have one problem here,

as shown in this picture,

dimensions expressions

i have 2 dimensions (OSPH Pemegang Saham and PH Awal Pemegang Saham) based on sql queries, that related many tables too,

and 2 expressions (OSPH Pemegang Saham (sum([OSPH Pemegang Saham])) and PH Awal Pemegang Saham (sum([PH Awal Pemegang Saham])))

and also no synth table found on table layout,

the problem is, when i create the pivot chart using sum function for both dimensions, i found 2 double values from the source, (marked red on the picture)

can anyone help me?

thanks

double values of sum function

Fri, 18 May 2012 08:58:37 GMT

Hi ,

Pls can u provide some more information.

I dont see any double values in the picture you posted.

Thanks,

Robinson

double values of sum function

Fri, 18 May 2012 10:15:02 GMT

selvaraj,

i just updated the picture, double values are marked red on the picture

thank you

double values of sum function

sridhar240784 — Fri, 18 May 2012 11:04:17 GMT

Hi,

Did you tried running your sql query in SQL Client (example TOAD or SQL SERVER) and chcked the value? are you not getting the double counted figure?

-Sridhar

double values of sum function

swuehl — Fri, 18 May 2012 11:15:11 GMT

I assume you just have multiple (double) records for these combinations of

OSPH Pemegang Saham and PH Awal Pemegang Saham

Maybe you could add a 3. dimension with a unique record ID (like rowno() created in the load)? This should show the multiple records then.

double values of sum function

Wed, 30 May 2012 06:39:02 GMT

thanks swuehl,

yeah finally the result correct, i forgot to add a unique dimension (transaction ID) before

OSPH Pemegang Saham and PH Awal Pemegang Saham .

thank you all