topic Re: Product code missing in one of the branches in QlikView

Product code missing in one of the branches

Sat, 11 Apr 2015 11:45:46 GMT

Hello!
I have a MySQL database, this bench I have the Products table, where I have a field that refers to the product code and another subsidiary of the investment, the 0006 is the stock, how can I do to show only the product code listed in 0006 and not included in other 5 branches?

Thanks

Re: Product code missing in one of the branches

vvvvvvizard — Sat, 11 Apr 2015 12:07:27 GMT

load

product_table as whateva_name ,

field

from ...

try adding

where product_table=6;

Re: Product code missing in one of the branches

anbu1984 — Sat, 11 Apr 2015 12:24:59 GMT

Can you provide sample input and expected output?

Re: Product code missing in one of the branches

Wed, 06 May 2015 21:27:57 GMT

Hello!

I have a table with the product code, the store that the product and quantity.

Database:

Code Shop Amount

0525 0001 10
0525 0002 34
0525 0003 15

0464 0001 5
0464 0002 3
0464 0003 8

0876 0001 20
0876 0002 0
0876 0003 0

I wish that the output is only listed products that are cleared in a store and others are in balance over 1.

Code Shop Quantity

0876 0001 20
0876 0002 0
0876 0003 0

thank you

Re: Product code missing in one of the branches

anbu1984 — Fri, 08 May 2015 06:01:02 GMT

Do you mean you want to list the products if atleast one of the store has no stock for a product and another store having stock more than for the same product? Then try this

T1:
Load * Inline [
Code,Shop,Amount
0525,0001,10
0525,0002,34
0525,0003,15
0464,0001,5
0464,0002,3
0464,0003,8
0876,0001,20
0876,0002,0
0876,0003,0 ];

Inner Join(T1)
Load Code Where Flag = 1;
Load Code,If(Min(Amount) = 0 And Max(Amount)>1,1,0) As Flag Resident T1 Group By Code;

Re: Product code missing in one of the branches

Sun, 10 May 2015 22:06:27 GMT

Thanks Anbu, solved my problem.