Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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>;
Hi,
True as said by tresesco you can try with concatenate.
Concatenate in Qlik is equivalent to Union All in SQL
Regards
ASHFAQ
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.
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.
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
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