topic Hierarchy Struggle ... in QlikView

Hierarchy Struggle ...

simonb2013 — Mon, 12 Aug 2013 14:10:40 GMT

So my first attempt at managing hierarchies is turning out to be a headache.

Though this is 'day 1' of QV for me.

Wondered if anyone could help me work out what I'd doing wrong ?

Script, tab 'Main':

--------------------------------------------------------------

ODBC CONNECT TO [myDatabasse];

SQL SELECT *

FROM "myDB"."mySchema"."Meta_QV_Hier_RollDomain";

objectType	objectName	UID	parentId
DM	KUNNR	4441105	0
RL	KUNNR_CPD	5021332	4441105

-----------------------------------------------------------

Script, tab 'Hier'

[Hier_RD]:

Hierarchy(UID,parentID,objectName,,objectName,[objectnamePath],|,objectDepth)

load

UID,parentId,objectName

Resident

Meta_QV_Hier_RollDomain;

Result:

The good part, is that for the second line, 1st 2 columns, I can see a relationship.

But the obvious bad part, is that I cannot see 'KUNNR_CPD' has a parent 'KUNNR' as far as the textual values are concerned.

I was expecting objectName="KUNNR", objectname1="KUNNR_CPD" ??

Any ideas what I'm doing wrong ?

Any help muchly appreciated ... going around in circles here

hic — Mon, 12 Aug 2013 15:40:43 GMT

You're almost there... You need to use parentId instead of parentID - it's case sensitive. So the Load should be

[Hier_RD]:

Hierarchy(UID,parentId,objectName,parentName,objectName,objectnamePath,'|',objectDepth)

load

UID,parentId,objectName

Resident

Meta_QV_Hier_RollDomain;

HIC

simonb2013 — Mon, 12 Aug 2013 17:09:09 GMT

Henric,

Oh my, thank you - what a relief !

I am curious now, as to what is happening behind the scenes when I had parentID in there.

Does it just 'make up' an empty column with the name ?

I'm suprised it did not throw an error

But yes, the practical provlem is solved !

Thank you.