topic Dynamically load data from qvd?????????/ in QlikView

Dynamically load data from qvd?????????/

balasundaram — Wed, 08 Jul 2015 09:42:04 GMT

Hi,

My dashboard loading data from 3 QVD's ( 2013.qvd, 2014.qvd, 2015.qvd).

My concern is if select year 2013 in front end only data need to load from 2013.qvd,

rest off qvd's no need to load.

How?

Re: Dynamically load data from qvd?????????/

alexandros17 — Wed, 08 Jul 2015 09:46:12 GMT

Qlik document first load all data then data is shown in layout so you cannot select something and then load some data (you can do it during the loading) otherwise you can only filter loaded data

Hopethis helps

Re: Dynamically load data from qvd?????????/

avinashelite — Wed, 08 Jul 2015 09:46:39 GMT

try like this :

Initialize a variable for the year in the script :

Passing variable to script :
Let vYear = Input('Enter Year (YYYY)' , 'Input required');

Load * from

table where

Year(date_Column)=$(vYear);

Then when you try to reload it will prompt for the input ...enter the year

Re: Dynamically load data from qvd?????????/

balasundaram — Wed, 08 Jul 2015 09:48:42 GMT

if i use same, user need to reload qvw

Re: Dynamically load data from qvd?????????/

avinashelite — Wed, 08 Jul 2015 10:07:46 GMT

reload from access point??

Re: Dynamically load data from qvd?????????/

Wed, 08 Jul 2015 20:33:48 GMT

Hi, Load all the QVD's data into qvw file. If user select any Year 2013 and lock the Year selection so this selection won't clear even though user clear the selection.