topic Re: Sum calculation mismatch in QlikView

Sum calculation mismatch

gautik92 — Mon, 04 Jan 2016 09:45:00 GMT

I have no of products with a serial no

product serial no must be unique

but in a pivot table am getting sum(quantity) as 2 for 1 serial no

any idea to solve this issue

Re: Sum calculation mismatch

senpradip007 — Mon, 04 Jan 2016 09:51:37 GMT

Can you share your sample app?

Re: Sum calculation mismatch

gautik92 — Mon, 04 Jan 2016 09:52:39 GMT

i cant share the app

Re: Sum calculation mismatch

PradeepReddy — Mon, 04 Jan 2016 09:55:48 GMT

can you please share the data model/sample data?

without know the details it is very difficult to guess the solution...

Re: Sum calculation mismatch

tamilarasu — Mon, 04 Jan 2016 09:56:56 GMT

Hi Gowtham,

You mentioned that Sum(Quantity) for a product as 2. I guess, the product's sold quantity is 2. Could you check the Quantity field against the product. ?

Re: Sum calculation mismatch

gautik92 — Mon, 04 Jan 2016 10:01:27 GMT

first column is sum(quantity) last column is serial no.

1 quantity should have unique serial no

issue is same serial no having 2 qty

Re: Sum calculation mismatch

puttemans — Mon, 04 Jan 2016 10:05:24 GMT

Hi Gowtham,

I'd work with a mapping in the script. In the mapping, you sum the quantities, grouped by the serial number. Then you map the sum in the table, based upon the serial number.

Regards,

johan

Re: Sum calculation mismatch

jonathandienst — Mon, 04 Jan 2016 10:48:47 GMT

Without knowing the quality of the data you are loading, what you are loading and some idea of the load script, it is not possible to say what is causing the problem, let alone trying to suggest solutions. I suggest that you prepare a sample that demonstrates the problem - use sample data that prevents disclosure of confidential information and reduce the data to a small subset to keep the upload size reasonable.

This article may help you: Preparing examples for Upload - Reduction and Data Scrambling