topic Re: How to implement sql query in the qlikview scripting in QlikView

How to implement sql query in the qlikview scripting

Tue, 03 Jun 2014 04:24:29 GMT

how to implement sql query

Re: How to implement sql query in the qlikview scripting

tresB — Tue, 03 Jun 2014 04:29:37 GMT

You can use the same sql query as it is in qv and fetch using 'SQL' command data like:

SQL <your query>;

Re: How to implement sql query in the qlikview scripting

Tue, 03 Jun 2014 05:07:06 GMT

No it is not working it is showing error

Re: How to implement sql query in the qlikview scripting

tresB — Tue, 03 Jun 2014 05:08:53 GMT

It works. If you are getting error, it has to be something with your approach. What is the error message you are getting?

Re: How to implement sql query in the qlikview scripting

jagan — Tue, 03 Jun 2014 05:36:26 GMT

Hi,

You need to give ; before the SQL keyword instead of comma.

Try like this

LOAD

SQL SELECT tab.*, Round((DateDiff("h",startdate,enddate)/24)-DateDiff("ww",startdate,enddate,1)-DateDiff("ww",startdate,enddate,7),2) AS durationdays, Round((DateDiff("n",startdate,enddate))-DateDiff("ww",startdate,enddate,1)*1440-DateDiff("ww",startdate,enddate,7)*1440,2) AS durationmin

FROM (SELECT [defect id], [New Value], [old value], [Change Date/Time] AS startdate, (SELECT TOP 1 [change date/time] FROM status_history next WHERE [defect id] = new.[defect id] and [Change Date/Time] > new.[Change Date/Time] and [old Value]=new.[New Value] order by [Change Date/Time]) AS enddate, (SELECT TOP 1 [new value] FROM status_history next WHERE [defect id] = new.[defect id] and [Change Date/Time] > new.[Change Date/Time] and [old Value]=new.[New Value] order by [Change Date/Time] ) AS nextValue FROM status_history AS new WHERE [changed field]='BG_STATUS') AS tab;

Regards,

Jagan.

Re: How to implement sql query in the qlikview scripting

Tue, 03 Jun 2014 06:11:48 GMT

i need write the script for it in qlikview no connection from sql.

Re: How to implement sql query in the qlikview scripting

its_anandrjs — Tue, 03 Jun 2014 06:26:49 GMT

As far as the concern about the excel data load use the ODBC connection for excel otherwise a way that you can load directly data from the excel files.

Load Fields...

From Location;