topic Exclude data and them put them in another place in QlikView

Exclude data and them put them in another place

Mon, 26 Jan 2026 18:19:17 GMT

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?

Exclude data and them put them in another place

Wed, 30 Sep 2009 20:23:29 GMT

Try this:

WHD:

SQL select * from WHA;

join select * from WHB;

join select * from WHC;

store WHD into WHD.QVD;

drop table WGD;

-Arun

Exclude data and them put them in another place

Wed, 30 Sep 2009 21:21:31 GMT

That does not work.

Exclude data and them put them in another place

Wed, 30 Sep 2009 22:20:37 GMT

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

Exclude data and them put them in another place

johnw — Thu, 01 Oct 2009 02:44:10 GMT

It sounds like you're just having a syntax problem. Try this:

if(Product='Phones','D',Warehouse) as Warehouse,

Exclude data and them put them in another place

Fri, 02 Oct 2009 14:58:11 GMT

YES...!

thx John, now it works!