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](/legacyfs/online/125397_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