Discussion Board for collaboration related to QlikView App Development.
The below condition consumes a long time in data reload,
WHILE Num ([Original Planned Delivery Date] + Iterno ()) <= Num (Today ())
any suggestions are welcome to reduce the load time.
Thanks in advance.
i ran my code against binary.qvw.
the file prior to reload had 1416 rows after reload its still 1416.
not all row items will have a delivery diff days value, if the calendar is NULL or NA - it will be null.
I did a line by line comparison between my code and the original code. my original solution just shows how you can calculate number of work days sourced from a different table.
to do the final test, I added your business rule to my code.
I added a new field where the business rule VALID (see attached) this is the stat resulting in my script, the total days diff matches 100%
but the original script had 861 more lines with 0 days diff than the new script. when I checked why, the original factory calendar values for these are either NULL or NA which I don't know is valid or not. see attached.
if you want to see the 861, just select/filter for Test=1