Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

archiving the data file

Hi,

i have 5 excel files with same structure but the data is different,i want to load all 5 files in qlikview.

the files names are 01122013,02122013,03122013,04122013 andso on (this is a date).

if the user selects a particular date like 01-dec-2013 the data should be loaded from that file or if user selects 04-dec-2013 the data should be loaded from that file.

this is actually archiving the data like if we want to see the previous day data he can go to date field and select a date n data will be populated with the data in that file.

plz can anyone help me with the code..

thanks

3 Replies
rajni_batra
Specialist
Specialist

You can use load * , FILENAME() , date(Date#(FILENAME()from,'DDMMYYYY'),'DD-MM-YYYY') as DATE

*.xlsx

it will laod all the files and will give you date field also

Hope this helps!!

Not applicable
Author

its not showing methe correct date
its showing 17-07-21481 if i put my myfile anem as07152013

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That's usually a bad idea. Better to load all the data and let the user make selections to filter the data on-the-fly. That's a lot faster then reloading on demand and a lot less likely to break down. If your systems amount of RAM memory is large enough to handle the data from all the source files then load all the data.

But if you insist you can try partial reloading. See this example.


talk is cheap, supply exceeds demand