topic How to get many tables from one select? in QlikView

How to get many tables from one select?

Mon, 19 Mar 2012 07:21:01 GMT

Hi All,

how could I change the below example into one SELECT to get three tables?

Department_1:
SELECT Name, Department FROM Employees WHERE Department = 1;
Department_2:
SELECT Name, Department FROM Employees WHERE Department = 2;
Department_3:
SELECT Name, Department FROM Employees WHERE Department = 3;

Thank you,

Przemek

How to get many tables from one select?

Mon, 19 Mar 2012 07:26:59 GMT

Hi,

if your qlikview application directly connected with db you can use following SQL statements

SQL Select * from Employees where Department <=3

Load * From Emplyees where Department <=3;

How to get many tables from one select?

Mon, 19 Mar 2012 07:35:23 GMT

Hi ijprakash,

what I mean is to get 3 seperate tables: Department_1, Department_2 and Department_3.

Thank you,

Przemek

How to get many tables from one select?

martinpohl — Mon, 19 Mar 2012 07:35:42 GMT

Hello Przemek,

in your select order QlikView will generate ONE table with all fields automatically because the table strustures are the same.

To generate three table you need a

noconcatenate load ....

Regards

How to get many tables from one select?

Mon, 19 Mar 2012 08:01:51 GMT

Hi Martin, good point. I've changed the code and coming back to my question - how to change it into one SELECT and get three tables.

NoConcatenate LOAD Name, Department;

Department_1: SELECT Name, Department FROM Employees WHERE Department = 1;

NoConcatenate LOAD Name, Department;

Department_2: SELECT Name, Department FROM Employees WHERE Department = 2;

NoConcatenate LOAD Name, Department;

Department_3: SELECT Name, Department FROM Employees WHERE Department = 3;

How to get many tables from one select?

martinpohl — Mon, 19 Mar 2012 08:13:35 GMT

for i = 1 to 3

Department_$(i):

noconcatenate select Name, Department from Emplyees where Department = $(i);

next;

But you will get three identical tables (from the structure)

Regards

How to get many tables from one select?

Mon, 19 Mar 2012 08:25:33 GMT

Thank you, Martin. I meant sth a bit different but you answer led me to the point.

Regards,

Przemek