Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

how to load data in based on file date?

hi guys,

I have a problem here...

I want to load data in based on the file date.

For exmaple:

i have a transaction file which have a report_date field.

it has data in 18-oct-2018, 19-0ct-2018,20-10-2018.

Howerver, the file sent to me is daily - trx_sales_20102018. Client just want transaction for 20 oct 2018 only.

So how can i do that? make sure that the loading the data in based on the file date????

Rgds

Jim

1 Reply
dilipranjith
Partner
Partner

What do you mean based on file date?

if you mean file modified date you can get it like below

Let vSetDate=Date(Floor(FileTime('Dummy.xlsx'))); (floor is to remove timestamp)

and use a where clause on your load and this variable