topic Re: script problem in QlikView

script problem

Mon, 26 Jan 2026 18:19:17 GMT

Dear All,

How to user this SQL query in qlikview script :

Select Level00,

Level02,

(

SELECT TOP 1 Level2

FROM demo m

WHERE m.ProductCode = tb.ProductCode

AND (

m.StoreCode = sm.StoreCode

OR m.StoreCode IS NULL

)

AND m.CreatedDate <= tb.CreatedOn

ELSE 1 END)

ORDER BY m.CreatedDate DESC

) AS 'Level2'

FROM dbo.User(NOLOCK) umr

INNER JOIN tempDemo tb ON tb.ModuleID = srm.ModuleID

Please reply..

Rahul

Re: script problem

crusader_ — Thu, 29 Jan 2015 13:48:56 GMT

Hi,

Create ODBC (OLE DB) connection to your database.

And use below script:

Table:

LOAD *

;

SQL

Select Level00,

Level02,

(

SELECT TOP 1 Level2

FROM demo m

WHERE m.ProductCode = tb.ProductCode

AND (

m.StoreCode = sm.StoreCode

OR m.StoreCode IS NULL

)

AND m.CreatedDate <= tb.CreatedOn

ELSE 1 END)

ORDER BY m.CreatedDate DESC

) AS 'Level2'

FROM dbo.User(NOLOCK) umr

INNER JOIN tempDemo tb ON tb.ModuleID = srm.ModuleID;

Hope this helps.

Regards,

Andrei Kaliahin

Re: script problem

Thu, 29 Jan 2015 13:59:34 GMT

thanks for reply but i am working on qvd so i have to create logic .

I can't fetch this from DB.

Re: script problem

crusader_ — Thu, 29 Jan 2015 14:01:37 GMT

Hm...

So each table from DB converted into QVD ?

Am I right?

Andrei

Re: script problem

Thu, 29 Jan 2015 14:28:05 GMT

yes...