This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a problem here...
I want to load data in based on the file date.
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????
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