topic Tree View / Hierarchy Display in QlikView

Tree View / Hierarchy Display

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

Hi all,

I have a data like no of values under one field, some of the values are header and some of the values are values to the headers.

I need to show this data in a hierarchy order like expending the values by clicking of plus symbol aside on the headers.

Attached sample data set and how the data to be displayed in dashboard.

swuehl — Thu, 11 Aug 2016 18:01:15 GMT

Maybe try something like

LOAD If(Parameter = 'Header',Header, Header & '/' & Value) as Tree, *;

LOAD *,

If(Parameter = 'Header', Aim, Peek(Header)) as Header,

If(Parameter = 'Header', '',Aim & recno()) as Value;

LOAD * INLINE [

Parameter, Aim

Header, Manage

Fieldvalue, Ad

Header, Labor

Fieldvalue, KLM

];

jegadeesan — Thu, 11 Aug 2016 19:09:18 GMT

Hi Stefan,

Thanks for your help and having one more scenario like having header under headers. As I given below.

-Header

-Header1

-Field Value

-Header2

-Field Value

-Header3

-Field Value