topic Re: 'select' sql script in qv script editor in QlikView

'select' sql script in qv script editor

surajap123 — Fri, 11 Jul 2014 12:23:42 GMT

Hi All,

I always thinking that qlikview doesnt support sql script(Eg-sql server/oracle). However, I see that, i can use any retrieving query(Eg-selct statement with join/where etc) below the load statment and click on reload button to fetch data from source database.

My question, is-

can i just use any complex sql code (with various joins and conditions)below the qlikview load statement to fetch data from db, so that i no need to do complex transformation in qlikview??

Re: 'select' sql script in qv script editor

Fri, 11 Jul 2014 12:27:16 GMT

Yes, that's possible

Kind regards

Re: 'select' sql script in qv script editor

datanibbler — Fri, 11 Jul 2014 12:32:48 GMT

Hi,

that is an interesting point - can anyone add a word or two on how that affects performance (under a c.p. scenario, is it better (in terms of resource-usage) to do transformations in SQL or in QV_script?

Since QlikView is not an SQL-based tool, but it "merely" supports the use of SQL, I suppose it should be faster to do transformations in QV_script?

Best regards,

DataNibbler

Re: 'select' sql script in qv script editor

rbecher — Fri, 11 Jul 2014 12:38:28 GMT

Hi Suraj,

everything after "SQL" is passed thru the connector. So, in the case of ODBC/OLEDB it's usually a SELECT statement of any complexity (it will not be touched at all), in case of other connectors it could be something different.

- Ralf

Re: 'select' sql script in qv script editor

maxgro — Fri, 11 Jul 2014 12:51:34 GMT

Re: SQL vs. QlikView for Complex Loads

Re: 'select' sql script in qv script editor

rbecher — Fri, 11 Jul 2014 12:56:17 GMT

I would say it depends. There is no one way or another...

Re: 'select' sql script in qv script editor

surajap123 — Thu, 17 Jul 2014 09:16:48 GMT

Thanks a lot for the valuable inputs..