Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

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