topic Re: loading different QVD files in QlikView

loading different QVD files

Fri, 19 Jun 2015 10:52:57 GMT

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);

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

Re: loading different QVD files

alexandros17 — Fri, 19 Jun 2015 10:54:49 GMT

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.

Re: loading different QVD files

vardhancse — Fri, 19 Jun 2015 10:57:54 GMT

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

Re: loading different QVD files

Fri, 19 Jun 2015 11:04:12 GMT

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.

Re: loading different QVD files

Fri, 19 Jun 2015 11:06:13 GMT

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

Re: loading different QVD files

Fri, 19 Jun 2015 11:07:56 GMT

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.

Re: loading different QVD files

vardhancse — Fri, 19 Jun 2015 11:09:25 GMT

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.

Re: loading different QVD files

RedSky001 — Fri, 19 Jun 2015 11:14:04 GMT

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.