Discussion Board for collaboration on QlikView Scripting.
I have a set of excel data file genreated for every week ..i'm using a for loop to pull everything in Qlikview
now the issue is from the latest file i need to pull some additional data ..
so i'm giving some conditon like if (data = max(date) after load statement and in the where clause
how to write a condition for something like this
plz help ..if my question doesn't make sense please let me know so that i can comeup with a better way of presenting the same question
Have a woderful weekend
EACH File in the fileist ('path'&* &'string')
This is the script for loading all the excel files in a folder
using year and month i can create a date field but
i want to use a where conditon to pull only one latest file where date is maximum
First Load everything into the QVD ..
From that qvd take the max date with the resident load and store that as an qvd...