SQL query convert into Qlik

[prma7799]

Hi  All ,

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

Your help will really appreciate.

Thanks

[bhaskar_sm]

Hi,

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

Regards,

Bhaskar 

[prma7799]

Sorry for late response.

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

Thanks

[bhaskar_sm · Accepted solution]

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

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