Loading Data From a View

[anuradhaa]

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

[#2]

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

[SunilChauhan]

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

hope this helps

[anuradhaa]

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

[SunilChauhan]

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

[#6 · Accepted solution]

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

[anuradhaa]

Thanks Guys,

Thanks a lot.

[#8]