Hello, I am trying to load the data from a file but i don't understand how to do it. I have files named as
filename _year_month_date.qvd. now I have to load all the data from august 2015 to jan 2016. I dont understand how to apply conditions on it. please help
That depends on your data type. A simply reload would be like:
Dates:
Load
Year,
Month,
Date
From
_year_month_date.qvd (qvd);
where the first line "Dates" is the name wich will recive your table on qlikview.
if you need to make a condition to load the table, you need to use "where" sentence and here is where it depends on your data type, for example:
Dates:
Load
Year,
Month,
Date
From
_year_month_date.qvd (qvd)
where Year >=2011 and Year <=2015
;
in this load you'll recive only data from 2011 to 2015 excludin all other data.
another example:
Dates:
Load
Year,
Month,
Date
From
_year_month_date.qvd (qvd)
where wildmatch(Month,1,2,3,4,5) and year = 2016
in this load you'll recive only data of year 2016 only month 1 to 5. excludin all other data. (depends on what kind of data you have on Month, it coul be text ('jan',feb,mar) or numbers(1,2,3,4).
If I understand the question you can use wildcard to load many files with a single load
This is from Qlik Help
The filename may contain the standard DOS wildcard characters ( * and ? ). This will cause all the matching files in the specified directory to be loaded.
