topic Re: Load data based on a selection in QlikView

Load data based on a selection

Mon, 11 Aug 2014 08:37:22 GMT

Is it possible to load data based on selection made by the user in the front end?

For eg., if user selects a Protein then I'd want to load the data related to that protein from multiple databases.

So, initially only the data on the list of proteins will be available while other data will be expired. Once a protein is selected, the remaining data will be refreshed by loading them from outside.

Please let me know if this is possible.

Re: Load data based on a selection

tresB — Mon, 11 Aug 2014 08:46:07 GMT

Have a look at my attachment here: Re: Reload based on selection

Re: Load data based on a selection

Mon, 11 Aug 2014 12:39:56 GMT

Thanks Tresesco...

Is it possible to select which source to load? For e.g., if I have load from 5 different sources, and I want to reload only one of the source. Is that possible?

Re: Load data based on a selection

tresB — Mon, 11 Aug 2014 13:00:51 GMT

Yes, you can. If you notice the variable used in the sample qvw vNamesToBeReloaded take the input from the front end as per user selection and then same is using in the script. You can write many ways to achieve your requirement. One simple way could be like:

if $(vNamesToBeReloaded) =1 then

load * from <path1>;

elseif $(vNamesToBeReloaded) =2 then

load * from <path2>;

else

load * from <Ptah3>;

end if

Re: Load data based on a selection

Mon, 11 Aug 2014 14:04:25 GMT

Thanks a lot. I see that we can write a piece of code in the load script. So is this where we make use of our VBA knowledge? Let me search on some material about scripting in QlikView.

Thanks again.