topic Hierarchy - is this possible? in QlikView

Hierarchy - is this possible?

Tue, 12 Apr 2011 18:33:58 GMT

Hi there,

does anyone have an idea how to create a hierarchy table to show last child in missing child fields (see example).

Br,

Przemek

AW:Hierarchy - is this possible?

Tue, 12 Apr 2011 19:33:12 GMT

Hello Przemek,

if I got you right, take a look at the calculated dimensions in your chart:

Regards,

Roland

AW:Hierarchy - is this possible?

Wed, 13 Apr 2011 07:25:33 GMT

Thanks, Roland. Looks good! I'm now wondering whether it can also be done dynamically i.e. when you add/remove a dimension it gets filled with last child.

BR,

Przemek

AW:Re: AW:Hierarchy - is this possible?

Wed, 13 Apr 2011 13:38:44 GMT

Hi Przemek,

take a look at the expressions. It shows in every dim the very last child (wasn't it "AccName"?). So if you delete one of the dims in the chart the others should work as well.