topic Re. :Total sum Customer1=Customer2 in QlikView

Total sum Customer1=Customer2

Thu, 20 May 2010 15:20:25 GMT

Don't know how do to this. I want total Qty where Customer1=Customer2

Try sum({1} total <[Customer1]>=[Customer2]> Qty) but don't work

Thanks very much

[Table1]:
LOAD * INLINE [
Customer1, Prd, CA
001, A, 10
001, B, 20
002, A, 40
003, C, 100
];

[Table2]:
OUTER JOIN (Table1) LOAD * INLINE [
Prd, Qty, Customer2
A, 1, 001
B, 1, 002
C, 1, 003
D, 1, 001
E, 1, 001
];

Total sum Customer1=Customer2

Thu, 20 May 2010 15:43:20 GMT

You expect then that Table2 entries without a corresponding Table1 entry will get Customer1 field set to Customer2 value?

Or summarise also when Customer1 is null?

Juerg

Re. :Re: Total sum Customer1=Customer2

Thu, 20 May 2010 15:54:06 GMT

Table 1 and Table 2 always correspond on field "prd"

thanks

Re. :Total sum Customer1=Customer2

Fri, 21 May 2010 10:02:17 GMT

SomeBody to help me ?

Thank you very much

Re. :Total sum Customer1=Customer2

Fri, 21 May 2010 12:40:36 GMT

You need to explain why you would expect the number 3 to show as your table has only 2 entries for Customer1 = 001.

You will get 3 for sum({1} TOTAL <Customer2> Qty)

And the {1} will ignore any selections you make - is this your intention?

Juerg

Re. :Re: Re. :Total sum Customer1=Customer2

Fri, 21 May 2010 15:30:14 GMT

Sorry, Here is a better exemple (Hope)

Thanks

[Table1]:
LOAD * INLINE [
Customer1, Prd, CA
001, A, 10
001, B, 20
002, A, 40
003, C, 100
001, A, 25
001, A, 45
];

[Table2]:
OUTER JOIN (Table1) LOAD * INLINE [
Prd, Customer2
A, 001
B, 002
C, 003
D, 001
E, 001
];

Re. :Re: Re. :Total sum Customer1=Customer2

martin59 — Fri, 21 May 2010 15:41:18 GMT

Hello,

You can try this :

count(Distinct if(Customer1=Customer2,Prd))

Re. :Re: Re. :Total sum Customer1=Customer2

martin59 — Fri, 21 May 2010 15:42:57 GMT

Here is my result :

Re. :Re: Re. :Total sum Customer1=Customer2

Fri, 21 May 2010 15:48:14 GMT

This is exactly what i want. Thank you very much