loading different QVD files

[#1]

Hello Team

   Kindly help me out to load the different QVD file based on the selection of year

1) 2000 to 2015 , years available in the list box , user want to load the qvd file based on selected year. user selecting 2000,2002,2012,

2) My QVD file start from Delivery_2000.qvd,Delivery_2001.qvd ......Delivery_2014

I am using the following code it is not working fine.

let vmin =  '$(vMinYear)';
let vmax = '$(vMaxYear)';
For zYear = vmin to vmax 
      Data:
          LOAD * From Booking_$(zYear).qvd (qvd);

     Next

can any one help me. this output should have to show based on the user selection years

[alexandros17]

First data are loaded then you can select dated, so you can load ALL the qvd then restrinct the range in listbox but you cannot load something when you select data in listbox.

[vardhancse]

Correct what Alessandro Saccone said is correct, we can not reload based on user selection.

The only thing is load full data and using some section access, we need to restrict the data

[#4]

user want to select the years because they don't want to load all the 10 or 15 years of data. Some user want 3 years some want 4 years like that.

[#5]

and there is no year in the table. but we have date

[#6]

Hey,

There is no way to load data as per user selection from front end, ...work around is, you can show them only the data in which they are interested by using section access or conditional show.

You can always make year from date.

[vardhancse]

And more over, in access point we can not enable reload option because it will be a performance issue.

We can go for direct discovery so that data will be linked to the dashboards.

[RedSky001]

This requirement seems a bit odd.

Are the users running qlikview on their local machines (ie File > Open)

or are they opening them on the server (ie File > Open in server) ?

This doesn't make any sense if they opening the files on the server as there is only one document held in memory.

Therefore if 1 user reloads the dashboard to see 2003 and 2004 then that is what everyone else will see.

Please be clearer with your requirement.