Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Suggestion Please

Dear All,

I have excel sheets it will updates daily basis ,in side huge records it will updates daily ,

But i am creating QVDs ,I am using QVDs in my application,

if i want get updates records mean am refreshing QVDs again i am using same QVDs in side application,

is there any way if i reload application QVDs and QVW both get updates records

here there is no Qlikview Server

Suggestion please ,help me to increase performence

Thanks In Advance

Niranjan

8 Replies
Not applicable

You can let your QVDs update automatically by going to Settings, Document Properties, Scheduler and then entering your preferred schedule!

Cheers,

Lucas

Not applicable

HI,

Go for Incremental Load then you can get updated records ,

Thanks

Nani

Not applicable

HI Lucas ,

If you do so Then for each reload you will get all the reords ,

if you shedule these Qvds with Incremental load then it will be k .

Thanks

Nani

NavinReddy
Creator II
Creator II
Author

Hi Nani,

first i will create QVD and then i can use in my application,(OR)

same application i will implement incremental load concept

Regards,

Niranjan

Not applicable

You can implement Incremental load in the same app and then you can shedule that application

with your timings ...

you will get the updated records...

Thanks

nani

NavinReddy
Creator II
Creator II
Author

It won't be decrease performance right ,because i have 50000 records

will incremental load decrease the performance

Best Regards,

Niranjan

sudeepkm
Specialist III
Specialist III

Incremental load will be a help in your case. Identify a logic and the associated fields based on which you want the incremental load to happen.

When you do incremental load a new QVD is created replacing the old one and having the data from the old QVD plus the updated records from the data source.

Not applicable

No it will not degrade your file performence...
For that need you better to create 2 QVW files 1 for QVDS and another  for your application ,

Thanks

Nani