topic Share your knowledge in QlikView

Share your knowledge

Tue, 13 Mar 2012 03:12:33 GMT

Hello,

I've 3 qvw files they are initial, incremental, current.

1. Initial :
This file creates the qvd file from scartch.

2. incremental:
This file appends the latest data to previously qvd file.

3. Current:
It loads the entire qvd file with lot of calculation it is taking lot of time to load entire qvd data everytime.

So what i want is, this file should hold previously loaded data and then it should retrive the latest data, after that this should append to previously loaded data. So it saves the time to reload b'coz, it doesn't require to calcualte again for previously loaded data.

I'm handling aroung 52GB qvd file in 96GB RAM.

How can i achive this? Is there anyway for this?

If you have any idea in different metthod also share me.

Share your knowledge

Tue, 13 Mar 2012 07:35:55 GMT

Buddy,

Please give any idea to me..

Share your knowledge

kaushiknsolanki — Tue, 13 Mar 2012 08:08:34 GMT

Hi,

Why dont u do calculations after getting incremental data.

Something like this.( this is just a logic)

If QVD is not exist.

Get data

Do calculation

Create QVD

If QVD exist

Get time stamp from existed QVD

Get incremated Data

Do claulation

Concat with existed QVD

Replace the QVD

Regards,

Kaushik Solanki

Re: Share your knowledge

Tue, 13 Mar 2012 08:35:52 GMT

Kaushik,

This is good idea. I'll develop that code and i'll test it, then i'll get back you. Thanks a lot to share KT to me.

Others any idea.