Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Left Join doesn't work. Mistake or too much data?

Hello everybody! (again )

QlikView crashes (Failure in script load dialog) doing this:

Item:
LOAD
    
"No_" as "Item No",

     "Item Type",

     ...other fields;
SQL SELECT
     "No_",

     "Item Type",
     ...other fields
FROM xxx;

ItemEntries:
LOAD

              "Item No_" as "Item No",  

               ...other fields;

SQL SELECT
     "Item No_",
     ...other fields
FROM ...xxx;

Let vFirstDate = Num('01.01.2011');
Let vLastDate = Num('31.08.2013);

For i = $(vFirstDate) To $(vLastDate)
ItemByMasterDate:
LOAD  "Item No",
    Date($(i)) as MasterDate
Resident Item;
Next i;

Left Join (ItemByMasterDate)
LOAD *
Resident ItemEntries;

DROP Table ItemEntries; //no synth. keys

Is there something wrong or are over 3 Million Entries in ItemEntries for this loads of MasterDates really too much, even for a big server?

I'm trying to do this: Sum up until dimension value . In my "old" solution it lasts some minutes... Therefore I'd like to use a Flag like tresesco suggested.

Or does someone has a idea for a good performance?

Thank you very much! (and also for your past answers and ideas)

Best regards,

Andreas

PS: Tried to replace the Resident with direct load... didn't help...

0 Replies