topic Loop Problem issue... in QlikView

Loop Problem issue...

Tue, 24 Apr 2012 08:50:57 GMT

Hi i have four tables... see tables below

ITEM

Item code, Item Desc

RECEIVING

Received date, Item code

DELIVERY

Delivery date, Item code

CALENDAR

Received date, Delivery Date

When I load these tables, it will have loop issue... Please help me get over this... I really wanted to have this calendar so that, when I will be getting data of 9-4-2009, it will show the data wherein Delivery date = 9-4-2009 and Received date = 9-4-2009

And to add, i also have comparison report like Delivery vs. Received.

So please, help me. Thanks.

Best Regards,

Bill

Loop Problem issue...

vincent_ardiet — Tue, 24 Apr 2012 09:11:47 GMT

Hi,

You can join manually your table like this :

ITEM:

load item code, item desc from item.qvd(qvd) ;

join load

item code, received date from receiving.qvd(qvd);

join load

item code, delivery date from delivery.qvd(qvd);

So you have only 1 table with all of your information in it.

Regards,

Vincent

Loop Problem issue...

Tue, 24 Apr 2012 09:20:25 GMT

Hi Vincent,

I forgot to tell you this

ITEM

Item code, Item Desc

RECEIVING

Item code, Received No

DELIVERY

Item code, Delivery No.

CALENDAR

Received date, Delivery Date

RECEIVE HEADER

Received No, Received date

DELIVERY HEADER

Delivery No., Delivery date

These are complete tables...

Loop Problem issue...

vincent_ardiet — Tue, 24 Apr 2012 09:33:18 GMT

Join all tables together.

RECEIVING and DELIVERY will join on Item Code.

The 2 headers will join on Received No and Delivery No.

Vincent

Loop Problem issue...

Tue, 24 Apr 2012 09:39:30 GMT

Will do your suggestion Vin, I hope it will work.

I have another concern, why is that 48MB of qvw load a bit slow. What should I do? How do I make it fast loading?

Loop Problem issue...

vincent_ardiet — Tue, 24 Apr 2012 09:58:30 GMT

It's hard to give you an answer concerning the speed, a lot of factors can interact (your computer memory, the size of the data, the way the tables are joined, the complexity of expression in your objects).

And what is slow exactly ? Opening your application ? Reloading data ? Refreshing sheets ?

Loop Problem issue...

Tue, 24 Apr 2012 10:01:55 GMT

In reloading data, I understand why it slows down. But how about in saving? Saving the application, like click the save button, it takes seconds. Is it really like that when your file is MB?

Loop Problem issue...

vincent_ardiet — Tue, 24 Apr 2012 11:31:27 GMT

On my side, i'm working today on an application with a 230MB QVW, QV takes 1GB of memory, there are 17 sheets, more than 200 objects and more than 8 millions of rows in the tables. And, it takes 60 seconds to save the file, ouch.

I tried to delete all sheets and it took the same time, so it's only due to the quantity of data.