What happens is that QlikView seems to start build up the hierarchy - but then nothing else happens. No error messages or something like that, but no progress whatsoever. It seems like it runs into an infinite loop.
We run it for several hours, but nothing happend so we had to interrupt the sript.
My first try was to split up the table in blocks of 100.000 records. This works fine - but I guess this can't be correct, as related IDs could be in different blocks, and therefore the hierarchy cannot be build up correctly.
Is there any other possibilty to get this to work? Any ideas why there is no progress in the script?