topic Re: count will increase when we use Hierarchy in QlikView

count will increase when we use Hierarchy

prma7799 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I am using below code for HIERARCHY but my GeoCount will increase

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 GeoDivision,

GLevelIndi,

GeoCount ,

Rmcount

FROM

[HQMaster.qvd]

(qvd);

Actual count is 477 for GLevelIndi 5 and GeoDivision 2 but it is showing 41953.

Re: count will increase when we use Hierarchy

tresB — Mon, 06 Aug 2018 10:19:54 GMT

May be because of the following reason:

Usually the input table has exactly one record per node and in such a case the output table will contain the same number of records. However, sometimes there are nodes with multiple parents, i.e. one node is represented by several records in the input table. If so, the output table may have more records than the input table.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptPrefixes/Hierarchy.htm

Re: count will increase when we use Hierarchy

prma7799 — Mon, 06 Aug 2018 10:36:25 GMT

Thanks for your reply ...

Could you please explain how to achieve this I mean I dont want to disturb Hierarchy but also want exact geocount i.e 477