topic Re: Sum function problems in QlikView

Sum function problems

Wed, 24 Feb 2016 18:33:23 GMT

Hello everyone,I have problem for sum(KDV).

Normaly write182,9463 in Sum(KDV) part but write irrelevant number in that part. If someone can help me ,i would be glad

Re: Sum function problems

Clever_Anjos — Wed, 24 Feb 2016 18:49:43 GMT

It would be easier to help if you post your qvw

Preparing examples for Upload - Reduction and Data Scrambling

Re: Sum function problems

Wed, 24 Feb 2016 19:11:56 GMT

Thanks for you interest.

Re: Sum function problems

Clever_Anjos — Wed, 24 Feb 2016 20:11:32 GMT

Which value are you supposed to see when summing KDV? 182,95?

Re: Sum function problems

sinanozdemir — Wed, 24 Feb 2016 20:25:11 GMT

Hey Murat,

Here is the result that you are looking for. I created another expression with Sum(Distinct KDV):

Since KDV repeats for "Teppich Traum" multiple times, you need to use Distinct in Sum() function. If you don't use Distinct, it will just sum all KDV values. That's why you were seeing aggregated KDV amount.

Hope this helps.

Thanks

Re: Sum function problems

Wed, 24 Feb 2016 20:40:16 GMT

Yes 182,95

Re: Sum function problems

Clever_Anjos — Wed, 24 Feb 2016 20:41:08 GMT

I can see your values repeat all over your data, maybe avg(KDV) instead of summing will return what you want

Re: Sum function problems

Wed, 24 Feb 2016 20:45:40 GMT

Thank you so much.( Çok Teşekkür ederim )

This is solution for me .

But normally kdv has one record or I can see one records.so I dont understand why this happening why 5,488