topic Re: Suggestion Please in QlikView

Suggestion Please

NavinReddy — Wed, 12 Mar 2014 11:59:53 GMT

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

Re: Suggestion Please

Wed, 12 Mar 2014 12:03:47 GMT

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

Cheers,

Lucas

Re: Suggestion Please

Wed, 12 Mar 2014 12:05:41 GMT

HI,

Go for Incremental Load then you can get updated records ,

Thanks

Nani

Re: Suggestion Please

Wed, 12 Mar 2014 12:09:37 GMT

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

Re: Suggestion Please

NavinReddy — Wed, 12 Mar 2014 12:32:59 GMT

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

Re: Suggestion Please

Wed, 12 Mar 2014 12:49:39 GMT

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

Re: Suggestion Please

NavinReddy — Wed, 12 Mar 2014 12:54:13 GMT

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

will incremental load decrease the performance

Best Regards,

Niranjan

Re: Suggestion Please

sudeepkm — Wed, 12 Mar 2014 12:56:26 GMT

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.

Re: Suggestion Please

Wed, 12 Mar 2014 13:01:49 GMT

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