Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
owhittle
Contributor
Contributor

Script Load - Latest records and date

Hi,

I have been struggling for quite a while and scanned the forums to come up with a method how to load the latest information from my qvd files which are created everything morning around 5 am from a database pull. This original qvd file I would not like to ammend as it is used by many applications.

I have another application where I would like to load the latest records e.g. max(date(Transact_time, 'DD/MM/YYYY')) or from the previous day. max(date(Transact_time, 'DD/MM/YYYY')-1). (my dates are all dates + times stamps)

TEMP:

LOAD

     max(Date) AS MAX_Date

FROM

[file1.qvd]

let vTemp=MAX_Date

drop table TEMP;

Table1:

LOAD

     Field 1

     Field 2

     Date

FROM

[file1.qvd]

WHERE Date >= $(vTEMP);

The above is an example of a method I have tried with no success as well as trying to Join/resident tables. The outcome I would like is if i have 1 years worth of data in a QVD, I am only targeting 1 day, however could have 1000 different timestamps which are all included in the load.

Hope this is clear.

1 Reply
ElizaF
Creator II
Creator II

Corect expresion for vTemp variable is:

let vTemp=Peek('MAX_Date',0,'TEMP');