Sum function problems

[#1]

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

[Clever_Anjos]

It would be easier to help if you post your qvw

Preparing examples for Upload - Reduction and Data Scrambling

[#3]

Thanks for you interest.

[Clever_Anjos]

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

[sinanozdemir · Accepted solution]

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

Other useful links by Sinan:

Handling Metadata in QlikView

QlikView and Python Integration

QlikView Automation Series – Unzip & Load Excel Files:

[#6]

Yes 182,95

[Clever_Anjos]

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

[#8]

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