topic Re: SQL query convert into Qlik in QlikView

SQL query convert into Qlik

prma7799 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

Can anyone help me to convert attached SQL script into Qlik..

Your help will really appreciate.

Thanks

Re: SQL query convert into Qlik

bhaskar_sm — Sun, 31 May 2020 16:02:14 GMT

Hi,

why do you want to convert the SQL statements in Qlik Script? you can run the SQL statements directly in qlikview

Regards,

Bhaskar

Re: SQL query convert into Qlik

prma7799 — Wed, 03 Jun 2020 09:47:13 GMT

Sorry for late response.

Actually when I am ran that query then I am getting error that invalid object t1.

Thanks

Re: SQL query convert into Qlik

bhaskar_sm — Wed, 03 Jun 2020 17:46:05 GMT

Hi,

have you tried debugging the query ?? below pice of a query is running ??

Please use WITH .. AS

Example:

SQL WITH app_owner AS (SELECT "ID","Owner_ID" FROM public."Apps") SELECT "Owner_ID", COUNT("ID") as "AppCount" FROM "app_owner" GROUP BY "app_owner"."Owner_ID";

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/How-to-load-without-SELECT.htm?_ga=2.185278506.200717561.1590991090-1545330843.1590991084

in your query, it will be like.

SQL WITH t1 as ( Select ...... )

kindly share the error message so that will be able to help you out.

I hope this will help

Thanks,

Bhasker