How to run Standard SQL queries in QlikView

[#1]

Hi All,

Hope all are doing great.

We are using google Biq Query as data source and we have created a view in big query using Standard SQL. When loading the data from that view i got below error message.

Can somebody help me in converting the Standard SQL to Legacy SQL in Qlikview or how to run the Standard SQL query in qlikview.

Thanks in advance.

Regards,

Nani

[Anonymous]

Which connector are you using?

This may be of help;

Qlik View BigQuery connector and Standard SQL

[#3]

Hi Gareth,

i have gone through that link. But we are using Qlik BigQuery connector .

[Anonymous]

This is all I can find in the help file, more specific to Qlik Sense not sure if you get the dialect option in Qlikview;

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/2.0/Google%20BigQuery/...