Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

question on suppressing a field from a dimension list

I'm trying to build a pivot table in the form of a tree structure.

I am aware of the 'Tree View'  but need to explore some other options.

I'm using the Hierarchy function to build my hierarchy view as below in the code segment:

##################################################################

H1:

Hierarchy(NodeId, ParentId, NodeName, , ,NodePath,|, NodeDepth)

LOAD

Node as NodeId,

Parent as ParentId,

NodeName as NodeName,

NodeName as REP_SUB_BS_ITEM,

IS_LEAF,

PRIORITY   

    

FROM

;

##################################################################

My question is this - assuming my maximum Nodedepth is at 8.

Based on the below code - how do I suppress the 9th column from displaying in my pivot chart.

I need to do this as I do not know how many levels I have in the unbalanced hierarchy.

Right now it is diplaying with "-"  as in the the attached image.

=pick(match(NodeDepth,'1','2','3','4','5','6','7','8','9'),

null(),

null(),

null(),

null(),

null(),

null(),

null(),

null(),

NodeName9

)

1 Reply
simenkg
Partner
Partner

Why not just remove N9 from the dimension list of the Pivot Chart?