topic Re: Loading Data From a View in QlikView

Loading Data From a View

anuradhaa — Fri, 19 Oct 2012 04:23:43 GMT

I'm using View in my data base to get data to my Qlikview report.

That View has 3-4 million records.

When i use that view and loading data it get stuck.

Please help me to solve this problem.

Please tell me how to load data from a view? is it possible in Qlikview

Thanks

Re: Loading Data From a View

Fri, 19 Oct 2012 05:11:15 GMT

Hi,

what's d message when it stucks ? Out of memory or something else....

How much RAM do u have on the system ?

Regards

Re: Loading Data From a View

anuradhaa — Fri, 19 Oct 2012 05:49:33 GMT

Hi,

It doesn't give any message.

it's not responding and i have to close it using task manager.

I have 4 GB ram

Thanks

Re: Loading Data From a View

Fri, 19 Oct 2012 06:22:24 GMT

Hi,

instead of full reload. try using debug & limited load of say 10 or 50 rows, just to check if its really an Hardware issue

Regards

Re: Loading Data From a View

anuradhaa — Fri, 19 Oct 2012 06:31:44 GMT

iF i use a where clause and limit the number of records it works fine.

This happen only in views.

It's ok with tables if there are millions of records.

Is anyone have the experiance of this.

I use qlikview 11

Re: Loading Data From a View

Fri, 19 Oct 2012 06:39:43 GMT

Hi,

try a workaround: say if u've a pkey numbered 1 to n.

The idea is something like this which can be fit to ur requirement

Load *;

select * from view

where pkey<1000 order by pkey;

concatenate

Load *;

select * from view

where pkey>=1000 order by pkey;

Regards

Re: Loading Data From a View

Mon, 22 Oct 2012 05:23:08 GMT

Hi,

Have u solved this problem ?

Regards

Re: Loading Data From a View

SunilChauhan — Mon, 22 Oct 2012 05:57:57 GMT

after connecting you need to give some time to load the application.

while loading heavy data is showing sometimes like system hang .

so have patience .

hope this helps

Re: Loading Data From a View

Mon, 22 Oct 2012 05:59:35 GMT

Hi,

but its has been mentioned that its ok if it's loaded from table.

Has it anything to do with the view ?

Re: Loading Data From a View

SunilChauhan — Mon, 22 Oct 2012 06:01:42 GMT

i can't understand what you have wrote.

can you please expalin in more detail.

Hope this helps

Re: Loading Data From a View

Mon, 22 Oct 2012 06:05:16 GMT

Hi,,

refer to the 4th post in the thread where its mentioned that:

4. Oct 19, 2012 12:01 PM (in response to anuradhaa)

Re: Loading Data From a View

iF i use a where clause and limit the number of records it works fine.

This happen only in views.

It's ok with tables if there are millions of records.

Is anyone have the experiance of this.

I use qlikview 11

which means that its ok if million rows are loaded from the table,it doesn't hang. It hangs only in case of a view.

why this is so ?

Regards

Re: Loading Data From a View

SunilChauhan — Mon, 22 Oct 2012 06:14:18 GMT

Its depends Upon data available in View. and also your configuration of system(RAM).

hope this helps

Re: Loading Data From a View

anuradhaa — Mon, 22 Oct 2012 06:19:41 GMT

My Ram is 4 GB.

Please try to load a data with out where clause from a view has 3+ tables and 10+ cloums.

i think you also get the same problem

Thanks

Re: Loading Data From a View

SunilChauhan — Mon, 22 Oct 2012 06:27:37 GMT

is it hang in case of single-single table.if not then check data model

or you can send a snap of your model.

hope this helps

Re: Loading Data From a View

Mon, 22 Oct 2012 10:38:55 GMT

hi Anuradhaa,

I already faced this problem. I was trying to load 10.5 million rows from the view, I solved it when I create 12 QVDs ( monthly ) instead of single load. although every thing said by Sunil (SK C) is right.

Regards

-Anil

Re: Loading Data From a View

anuradhaa — Mon, 22 Oct 2012 11:02:40 GMT

Thanks Guys,

Thanks a lot.

Re: Loading Data From a View

Mon, 22 Oct 2012 11:16:23 GMT