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