topic Re: Quantities versus sum in QlikView

Quantities versus sum

Tue, 17 Dec 2013 15:03:06 GMT

Hello;

I am working on an application where the quantities are correct, but whenever I ask the sum of these the system multiplies the quantities by 4. No ideas where this is coming from. Do you?
Many thanks in advance.

Kristel

Re: Quantities versus sum

kaushalview — Tue, 17 Dec 2013 15:27:27 GMT

Hi Kristel,

Issue:

Problem is Duplication in table.

Resolution:

1) Check in script tab 'Currency Mapping' ,You have used Inner Join between two table with joining of two fields Which is wrong If you want use two fileds for joining then create composite key Like'[From currency_FCURR] &[To-currency_TCURR] '.

2) Check in script tab 'Cons Sales Order' and 'Currency Mapping' table.In these two table which is the common fileds.

3) Check and load one table with exit script step by step.

Regards

Kaushal Mehta.

Re: Quantities versus sum

Tue, 17 Dec 2013 15:29:31 GMT

Hi Kristel,

In your app is every line 4 times. So you see 1 distinct line in the tablebox, but 4 * quantity in the Chart.

Best regards

Henry

Re: Quantities versus sum

kaushalview — Tue, 17 Dec 2013 15:35:44 GMT

Hi Kristel,

In your application the Orderqauntity fileds value showing $ times.If you want to check then use show frequency option in list box.

Solution is mantioned above

Regards

Kauhal Mehta

Re: Quantities versus sum

Thu, 13 Feb 2014 12:16:04 GMT

Understand your point, thanks for helping.

Re: Quantities versus sum

Thu, 13 Feb 2014 12:16:57 GMT

Again, thanks for helping. I know now what to look for!