topic Re: Sum expressions in QlikView

Sum expressions

Thu, 24 Jan 2013 10:15:49 GMT

hi,

I have calculate sum of data. Some values are same so i cannot use DISTINCT as well. If I use sum(field) , it is not displaying the correct data. please help me with the expressions.

thanks

Re: Sum expressions

Thu, 24 Jan 2013 10:18:06 GMT

Dear thejaswini,

Can you post the sample file.

so that we can help you.

Thanks,

Mukram.

Re: Sum expressions

Thu, 24 Jan 2013 10:26:48 GMT

Consider these 3 field values.

35.40, 35.79 & 35.79

I have to take the sum . If i use sum(filed), it is not matching with the actual sum ( ie., . 106.98). I am getting 14777 as the sum .

If i use sum(DISTINCT(field)), all 3 values will not be taken becoz 2 values are similar.

thanks

Re: Sum expressions

Thu, 24 Jan 2013 10:29:38 GMT

Hi,

try using sum(TOTAL <field>).

Regards,

Anju

Re: Sum expressions

Thu, 24 Jan 2013 10:33:26 GMT

Dear thejaswini,

if sum the above three Values it will give you 106.98.

but why your getting 14777 i don't no..

kindly find the attachment .

i hope it will help you.

Thanks,

mukram

Re: Sum expressions

Thu, 24 Jan 2013 10:35:17 GMT

Hi anju,

I tried using, but it dint get resolved

Re: Sum expressions

Thu, 24 Jan 2013 10:42:37 GMT

Hi Thejaswini,

Could you please post your qvw file?

Regards,

Anju

Re: Sum expressions

khadeer — Thu, 24 Jan 2013 10:46:33 GMT

It is problem in data model. Post ur QVW. Then it helps me to resolve ur issue.