topic Re: How to run Standard SQL queries in QlikView in QlikView https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278229#M852153 <HTML><HEAD></HEAD><BODY><P>Which connector are you using?</P><P></P><P>This may be of help;</P><P></P><P><A href="https://community.qlik.com/thread/243628">Qlik View BigQuery connector and Standard SQL</A></P></BODY></HTML> Tue, 28 Feb 2017 09:53:07 GMT Anonymous 2017-02-28T09:53:07Z How to run Standard SQL queries in QlikView https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278228#M852152 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Hope all are doing great.</P><P></P><P>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.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/154703_Capture.PNG" style="height: 249px; width: 620px;" /></P><P>Can somebody help me in converting the Standard SQL to Legacy SQL in Qlikview or how to run the Standard SQL query in qlikview.</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P><P>Nani</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278228#M852152 2020-11-25T16:16:04Z Re: How to run Standard SQL queries in QlikView https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278229#M852153 <HTML><HEAD></HEAD><BODY><P>Which connector are you using?</P><P></P><P>This may be of help;</P><P></P><P><A href="https://community.qlik.com/thread/243628">Qlik View BigQuery connector and Standard SQL</A></P></BODY></HTML> Tue, 28 Feb 2017 09:53:07 GMT https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278229#M852153 Anonymous 2017-02-28T09:53:07Z Re: How to run Standard SQL queries in QlikView https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278230#M852154 <HTML><HEAD></HEAD><BODY><P>Hi Gareth,</P><P></P><P>i have gone through that link. But we are using <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Qlik BigQuery connector .</SPAN></P></BODY></HTML> Tue, 28 Feb 2017 10:04:16 GMT https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278230#M852154 2017-02-28T10:04:16Z Re: How to run Standard SQL queries in QlikView https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278231#M852155 <HTML><HEAD></HEAD><BODY><P>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;</P><P></P><P><A href="https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/2.0/Google%20BigQuery/Create-GBQ-Connection-with-Add-data.htm" title="https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/2.0/Google%20BigQuery/Create-GBQ-Connection-with-Add-data.htm">https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/2.0/Google%20BigQuery/Create-GBQ-Connectio…</A></P></BODY></HTML> Tue, 28 Feb 2017 13:02:27 GMT https://community.qlik.com/t5/QlikView/How-to-run-Standard-SQL-queries-in-QlikView/m-p/1278231#M852155 Anonymous 2017-02-28T13:02:27Z