Help with set analysis

slefranc — Tue, 10 Jun 2014 13:15:03 GMT

Hi,

I need some help with a set analysis expression that I can't build by myself.

Here is the deal :

- In one hand, I have some products in my stock. Each product has its own "p_id", and a reference "ref"

- On the other hand, I have some wishes "w_id" from customers on differents references "ref"

products:

LOAD * inline [p_id,ref

P1,REF A

P2,REF A

P3,REF B

P4,REF C

P5,REF C

];

wishes:

LOAD * inline [w_id,ref

W1,REF A

W2,REF A

W3,REF A

W4,REF A

W5,REF B

W6,REF D

];

The fact is that some wishes will not be satisfied because I have not enough stock of the wish reference

My problem is to evaluate with a single expression the number of wishes that could be satisfied. In the example above, it would be 3 (2 wishes for the "REF A" and 1 wish for the "REF B").

I don't want to use a graphic (I know how to do that).

I'm sure it's possible, but I really don't know how ! Thx for your help.

topic Help with set analysis in QlikView

Help with set analysis