topic Re: Hierarchy belong to script error in QlikView

Hierarchy belong to script error

vikasmahajan — Tue, 22 Jul 2014 09:26:15 GMT

Dear all

Following is my script I am getting script error what could be problem in script , I want to try belongs to option.

Vikas

HierarchyTemp:

HIERARCHY(CHILD_ID, PARENT_ID, [HQ], [Parent Name], [HQ], [Path Name], '/')

LOAD Hqid AS [HQ Code],

Hqname AS [HQ],GeoLevelName AS [Level Name],

CHILD_ID, PARENT_ID,

Sgid as [Sales Group Code],

GeoCount ,

Rmcount,

[EmpName],

[Email]

FROM

[..\Qvds\DIM_GeoHQMaster.qvd]

(qvd);

Ancestor_Table:

HierarchyBelongsTo (CHILD_ID,PARENT_ID, [HQ],Ancestor_ID,Ancestor_Name,DepthDiff)

LOAD

Distinct

[HQ Code],

[HQ] ,

[EmpName]

RESIDENT HierarchyTemp;

drop table HierarchyTemp;

Re: Hierarchy belong to script error

matthewjbryant — Tue, 22 Jul 2014 09:33:15 GMT

HI Vikas. What's the error?

Re: Hierarchy belong to script error

matthewjbryant — Tue, 22 Jul 2014 09:39:29 GMT

In the information I've been reading lately it seems you would generally only have one connected column between these two tables (i.e. Parent_ID and [HQ] need changing in Ancestor_Table.

I don't think that's the source of the error though.

Re: Hierarchy belong to script error

vikasmahajan — Tue, 22 Jul 2014 10:29:59 GMT

resolved with by putting CHILD_ID in

Ancestor_Table:

HierarchyBelongsTo (CHILD_ID,PARENT_ID, [HQ],Ancestor_ID,Ancestor_Name,DepthDiff)

LOAD

Distinct

CHILD_ID,

[HQ Code],

[HQ] ,

[EmpName]

RESIDENT HierarchyTemp;

drop table HierarchyTemp;

Solve my error.

Thanks

Vikas