topic Re: Hierarchy path sort order in QlikView

Hierarchy path sort order

Anonymous — Tue, 24 Nov 2015 14:48:27 GMT

Hi,

Im stuck with the sort order in a hierarchy path.

It works to this point.

KstHierarchie:

Load

Cost_Center,

KST_Stufe_2 as KstHierarchiePath

Resident Kostenstellenhierarchie;

LOAD

Cost_Center,

if(isnull(KST_Stufe_3), KST_Stufe_2 & '\' & Cost_Center,

KST_Stufe_2 & '\' & KST_Stufe_3) AS KstHierarchiePath

Resident Kostenstellenhierarchie

where not isnull(KST_Stufe_2);

What i want to do now is to order the items in this hierarchy in a certain matter.

The sort order comes right out of the SAP table.

For example:

Item	SEQNR
Cost_Center_X	1
Cost_Center_Y	2
Cost_Center_Z	3

But no matter what (order by....), it wont order in the right way.

Can somebody help me?

Cheers,

Phil

Re: Hierarchy path sort order

sinanozdemir — Tue, 24 Nov 2015 15:05:34 GMT

Can you provide some sample data? You can also try to add Order By in your load script.

Re: Hierarchy path sort order

rubenmarin — Tue, 24 Nov 2015 15:25:50 GMT

Hi Philipp, have you tried a join?:

KstHierarchie:
Load
Cost_Center,
KST_Stufe_2 as KstHierarchiePath
Resident Kostenstellenhierarchie;
LOAD
Cost_Center,
if(isnull(KST_Stufe_3), KST_Stufe_2 & '\' & Cost_Center,
KST_Stufe_2 & '\' & KST_Stufe_3) AS KstHierarchiePath
Resident Kostenstellenhierarchie
where not isnull(KST_Stufe_2);
Left Join
LOAD Item as Cost_Center,
SEQNR as Sort
FROM ...