Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hierarchy: The expanding nodes don't stop

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);

13 Replies
sundarakumar
Valued Contributor II

Re: Hierarchy: The expanding nodes don't stop

Hi Erlen,

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

Capture.PNG

-Sundar

Not applicable

Re: Hierarchy: The expanding nodes don't stop

Hello.

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

Thanks.

Untitled.png

marcus_malinow
Valued Contributor III

Re: Hierarchy: The expanding nodes don't stop

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

Not applicable

Re: Hierarchy: The expanding nodes don't stop

Very strange. I'll keep trying.

sundarakumar
Valued Contributor II

Re: Hierarchy: The expanding nodes don't stop

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

in my case it was done in 2 seconds.

-Sundar

Not applicable

Re: Hierarchy: The expanding nodes don't stop

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

Not applicable

Re: Hierarchy: The expanding nodes don't stop

The execution enter in a infinity loop.

Capture.PNG.png

sundarakumar
Valued Contributor II

Re: Hierarchy: The expanding nodes don't stop

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

Capture.PNG

-Sundar

Not applicable

Re: Hierarchy: The expanding nodes don't stop

Not Work.

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

Community Browser