topic Re: archiving the data file in QlikView

archiving the data file

Fri, 26 Jul 2013 07:02:29 GMT

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

Re: archiving the data file

rajni_batra — Fri, 26 Jul 2013 07:12:55 GMT

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!!

Re: archiving the data file

Fri, 26 Jul 2013 09:32:11 GMT

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

Re: archiving the data file

Gysbert_Wassenaar — Fri, 26 Jul 2013 09:43:07 GMT

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.