Re: Hierarchy: The expanding nodes don't stop - Qlik Community

Report Inappropriate Content · ‎2014-02-25

What is wrong when I run the code below in the attached QVD.

The expanding nodes don't stop.

Test:

Hierarchy(SCC_ID, SCC_IDpai, SCC_descricaoplanocontas,ParentName,SCC_descricaoplanocontas,Path,'/',Depth)

Load * from C:\TEMP15.qvd (qvd);

sundarakumar · ‎2014-02-26

Hi Erlen,

Can u pls explain the problem, PFB i find it working correct

-Sundar

Report Inappropriate Content · ‎2014-02-26

Hello.

In my case, the script never stops and the data are growing.

Thanks.

marcus_malinow · ‎2014-02-26

I tried your script also and it worked just fine

Test-NodeList << TEMP15 (qvd optimized) 9,612 lines fetched

Test << ExpandedLeaves 26,508 lines fetched

Report Inappropriate Content · ‎2014-02-26

Very strange. I'll keep trying.

sundarakumar · ‎2014-02-26

Then u kill the process to stop it. How long is it running?

in my case it was done in 2 seconds.

-Sundar

Report Inappropriate Content · ‎2014-02-26

When I press "Abort", the script execution stops immediately.

Report Inappropriate Content · ‎2014-02-26

The execution enter in a infinity loop.

sundarakumar · ‎2014-02-26

try reloading the app only with the three mandatory fields for hierarchy...

-Sundar

Report Inappropriate Content · ‎2014-02-26

Not Work.

I've tested it on 3 different machines and not work at all. the script never stops.