topic Re: How to use union all select query in qlikview in QlikView

How to use union all select query in qlikview

Tue, 12 Aug 2014 05:33:07 GMT

Hi,

I need to create a qlikview report. There is a MySQL query, the logic of the query should be used and the qlikview report should be generated. MySQL source query contains two select queries with an Union all between them. How do i do an union all in our qlikview. Its bit urgent. Can anyone guide me with clear picture so that i can make use of it.

Thanks,

Sase

Re: How to use union all select query in qlikview

tresB — Tue, 12 Aug 2014 05:39:48 GMT

Use concatenate like:

Table1: Load * From <source1>;

Concatenate // this would not be required if all the fields from two tables are common

Load * From <souerce2>;

Re: How to use union all select query in qlikview

ashfaq_haseeb — Tue, 12 Aug 2014 05:43:41 GMT

Hi,

True as said by tresesco you can try with concatenate.

Concatenate in Qlik is equivalent to Union All in SQL

Regards

ASHFAQ

Re: How to use union all select query in qlikview

Tue, 12 Aug 2014 05:47:01 GMT

tresesco's is right. But why do you want to do a union in Qlikview here? Your example can have the UNION ALL in your select itself.

Re: How to use union all select query in qlikview

amit_saini — Tue, 12 Aug 2014 05:48:42 GMT

Kumar,

Follow this link:

Re: How can we do union in qlikview.

Thanks,
AS

Re: How to use union all select query in qlikview

jagan — Tue, 12 Aug 2014 05:52:56 GMT

Hi Kumar,

You can use your UNION ALL query directly in the dashboard and there is no need of splitting, suppose if you want to do it in Qlikview then use Concatenate() like below

Data:

SELECT

FROM Table1;

Concatenate(Data)

SELECT

FROM Table2;

Concatenate(Data)

SELECT

FROM Tablen;

Hope this helps you.

Regards,

Jagan.

Re: How to use union all select query in qlikview

forte — Tue, 12 Aug 2014 06:25:15 GMT

Hi Kumar ,

It should be not best option, but you can ever use original Query in order to obtain a fast result.

MyReportTable :

SQL SELECT field1, field2 .. from table1

union all

select field 3, field4 ... from table2;

You just obtain same result as query cursor. You can use any query accepted by your driver connector (join, union and even call stored procedures).

Regards

Re: How to use union all select query in qlikview

Tue, 12 Aug 2014 12:18:07 GMT

Hi,

Thanks a lot for everyone, i am trying all the possible approaches given and will let u know whether i am getting what i need,,

Thanks