Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Loop Problem issue...

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

Tags (2)
7 Replies
vincent_ardiet
Contributor III

Loop Problem issue...

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

Not applicable

Loop Problem issue...

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...

vincent_ardiet
Contributor III

Loop Problem issue...

Join all tables together.

RECEIVING and DELIVERY will join on Item Code.

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

Vincent

Not applicable

Loop Problem issue...

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?

vincent_ardiet
Contributor III

Loop Problem issue...

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 ?

Not applicable

Loop Problem issue...

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?

vincent_ardiet
Contributor III

Loop Problem issue...

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.

Community Browser