Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

balasundaram
Contributor II

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

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?

5 Replies

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

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?????????/

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 

balasundaram
Contributor II

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

if i use same, user need to reload qvw

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

reload from access point??

Not applicable

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

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.

Community Browser