How to use union all select query in qlikview

[#1]

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

[tresesco]

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>;

[ashfaq_haseeb]

Hi,

True as said by tresesco you can try with concatenate.

Concatenate in Qlik is equivalent to Union All in SQL

Regards

ASHFAQ

[#4]

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.

[amit_saini]

Kumar,

Follow this link:

Re: How can we do union in qlikview.

Thanks,
AS

[jagan]

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.

[forte]

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

[#8]

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