sql select with parameter

[swiftfahad]

Hi grus:

I am facing a problem that I have connect my Qlikview to oracle through connector. I have a complex view '"View_Employee_Data" in oracle retrieving 10 years records.  with some functions performing calculations.

This view work fine if where clause have some parameter like employee id etc. This view takes lot of time on select * all.

is there any possibility to load that view into qvd file base on user selection on dashboard? qlikview takes lot of time while fetching full data from that table.

plz advice

[shiveshsingh]

What do you mean by this?

is there any possibility to load that view into qvd file base on user selection on dashboard?

[dplr-rn]

i think you have misunderstood what a qvd is. QVD is used as a data store (similar to csv but more efficient) to enable fast loads into a Qlik application.
Once a dashboard is reloaded, qvd is no longer used. all data needed for dashboard is loaded into the QVF file

In your case i suggest you implement incremental load. i.e. load only new and updated records. see below link for details
https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/