topic Re: Question Regarding the select Query in Qlikview in App Development

Question Regarding the select Query in Qlikview

Jay587 — Fri, 15 Nov 2024 21:27:14 GMT

Hello All,

I have a question regarding the query which I have received so that I need to make work it on Qlikview. I'm mentioning the sample query here ,please let me know if it works or not and will I get the correct data ?

----Connection String------

SQL SELECT

t1.order no,

t2.orderline,

t3.orderamount,

t4.ordersku,

t5.netsales,

t6.others

FROM apps.tab1 t1,
apps.tab2 t2,

apps.tab3 t3,

apps.tab4 t4,

apps.tab5 t5,

apps.tab6 t6;

Please suggest me this kind of queries will work on qlikview or Is it required to join those tables ?

Thanks in advance.

Re: Question Regarding the select Query in Qlikview

marcus_sommer — Fri, 25 Aug 2023 12:55:35 GMT

Qlik doesn't execute a sql-statement else transferred it per driver to the data-base and received on this way back the results. Means everything what worked within the data-base and is supported by the used driver will return valid results within Qlik.

Beside this the shown snippet is a join even if it's not explicitly mentioned in the query. And if you pull all single-tables into Qlik you will need there also a join-approach to merge the fields from different tables. In general a join is in Qlik the same as in sql but all equally field-names are key-fields and no conditions could be added to these keys.