Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a database which contains various products sorted by warehouse.
Warehouse A : Phones, laptops, desktops, flatscreens
Warehouse B: Tables, chairs, buildings
Warehouse C: Cars
I want to create a fictive warehouse in Qlikview and call it Warehouse D. In this fictive warehouse I want to store all phones. So I want to remove it from warehouse A and put in in warehouse D without changing my original database,
I'm guesing something like, select * from warehouse where product = NOT phones and then running a different script to put them in the other warehouse?
I've managed to exclude the phones from warehouse A with a script but what's the next step? Next I've created a new codeline where I exclude everything BUT the phones. I don't know how to put that selection as a new Warehouse?
Anyone can help?
It sounds like you're just having a syntax problem. Try this:
if(Product='Phones','D',Warehouse) as Warehouse,
Try this:
WHD:
SQL select * from WHA;
join select * from WHB;
join select * from WHC;
store WHD into WHD.QVD;
drop table WGD;
-Arun
That does not work.
I've tried this also but it does not work:
Load
Product,
Warehouse 'A' as 'D' if(Product='Phones'),
Price
From D:\qlikview\inventory.csv
It sounds like you're just having a syntax problem. Try this:
if(Product='Phones','D',Warehouse) as Warehouse,
YES...!
thx John, now it works!