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

[balasundaram]

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?

[alexandros17]

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

[avinashelite]

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]

if i use same, user need to reload qvw

[avinashelite]

reload from access point??

[#6]

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.