Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mschreiber
Contributor III
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

0 Replies