Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

mschreiber
New Contributor III

different behavior Hierarchy Load between QlikView and QlikSense

Hello anyone,

I have a problem with a different behavior between QlikView v12SR2 and QlikSense 2.2.4 with a hierarchy load statement:

Hierarchy(NodeID, ParentID, NodeName, ParentName, NodeName, PathName,' > ', Ebene)

LOAD

        %RowNo_Fakten,            //Schlüssel zu Fakten

        ChildDim_tmp   as NodeID,

        ParentDim_tmp  as ParentID,

        ChildName_tmp  as NodeName

Resident Fakten_final

;

In QlikView this statement works fine. In QlikSense this statement produce millions of rows, but the source data and the script code between QV and QS is identical.

hierarchy.png

In sum the QS Statement produce 67 Mio. rows and after additional Statements it hangs up.

Anyone experience with hierarchy load in QlikSense ?

Is there a difference between QV and QS ?

Is the QIX engine not the same between QV 12 and QS 2.2 ?

Thank in advance

Mathias

Tags (1)
Community Browser