Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

sql select with parameter

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

2 Replies
Master
Master

What do you mean by this?

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

Highlighted
Partner
Partner

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/