Design Approach

Report Inappropriate Content · ‎2013-12-02

Hi,

We are having a requirement where in we are using a FromDate and ToDate check and getting records based on it.

There are around 150 million records in a table say "A" and other tables are also present wherein we fetch data.

whenever we fetch data from table A based on dates,its taking lots of time and making application slower.

we are new to qlikview and dont know how to arrive at a better design.

Do you have any idea?

can you please let me know.

Thanks in advance.

Poornima

vikasmahajan · ‎2013-12-02

Hiii,

I think you need to apply incremental load concept .

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-12-02

do u have any samples

or links on it?

sujeetsingh · ‎2013-12-02

for incremental load go to this link

Incremental Data Load in Qlikview « Learn Qlikview

Report Inappropriate Content · ‎2013-12-02

Hi,

can you please attach your sample data here which you are using to fetch data from other table.

It will be helpful to understand your problem.

Regards,

Ashutosh

vikasmahajan · ‎2013-12-03

You can search in community for incremental load there are lot of posts !!!!!!!

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-12-03

Hi Narayan,

Please go through the link : http://community.qlik.com/message/389578#389578

There are good videos as well which shows the sample in QlikTips(Youtube).

Hope this helps!

Thanks,

Sai

Related Topics