topic Re: Script QVW in QlikView

Script QVW

Anonymous — Tue, 20 Oct 2015 10:53:27 GMT

How could I convert script SQL to QVW

SQL :

from [dbo].[Vente] t

INNER join [dbo].tempOCMPX r

on t.[Date Time] between r.[DATE DEBUT] and r.[DATE FIN]

Script QVW:

LEFT JOIN (Vente)

LOAD

code4 ,

datecol,

[Code Site],

Comp;

SQL SELECT [Date Time] as datecol

,[Code Site]

,[Code Rayon] as code4

,[comp] as Comp

FROM [QlikDataWarehouse].[dbo].tempCOMP

Re: Script QVW

swuehl — Tue, 20 Oct 2015 11:03:54 GMT

You don't need to convert because you can use your SQL in the QV script as well.

Everything after SQL SELECT is sent to and executed by your DBMS.

Re: Script QVW

Anonymous — Tue, 20 Oct 2015 11:12:03 GMT

You can just do this:

Table:

SQL SELECT [Date Time] as datecol

,[Code Site]

,[Code Rayon] as code4

,[comp] as Comp

FROM [QlikDataWarehouse].[dbo].tempCOMP;

left join (Table)

SQL SELECT *

FROM [QlikDataWarehouse].[dbo].tempOCMPX

Be careful of not creating syn keys

Re: Script QVW

SreeniJD — Tue, 20 Oct 2015 11:17:30 GMT

As suggested by Thabang..

Use the suggested script.. and also use Qualify statement to avoid syn keys

Sreeni