Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
what's d message when it stucks ? Out of memory or something else....
How much RAM do u have on the system ?
Regards
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
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
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
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
Hi,
Have u solved this problem ?
Regards
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
Hi,
but its has been mentioned that its ok if it's loaded from table.
Has it anything to do with the view ?
i can't understand what you have wrote.
can you please expalin in more detail.
Hope this helps