topic Re: Design Approach in QlikView

Design Approach

Tue, 03 Dec 2013 04:14:38 GMT

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 — Tue, 03 Dec 2013 04:33:19 GMT

Hiii,

I think you need to apply incremental load concept .

Vikas

Tue, 03 Dec 2013 04:37:09 GMT

do u have any samples

or links on it?

sujeetsingh — Tue, 03 Dec 2013 04:44:38 GMT

for incremental load go to this link

Tue, 03 Dec 2013 04:51:46 GMT

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 — Tue, 03 Dec 2013 05:02:19 GMT

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

Vikas

Tue, 03 Dec 2013 07:30:12 GMT

Hi Narayan,

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

Hope this helps!

Thanks,

Sai