Tree View / Hierarchy Display

[jegadeesan]

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]

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

Fieldvalue, Ad

Fieldvalue, Ad

Fieldvalue, Ad

Fieldvalue, Ad

Fieldvalue, Ad

Fieldvalue, Ad

Header, Labor

Fieldvalue, KLM

Fieldvalue, KLM

Fieldvalue, KLM

Fieldvalue, KLM

Fieldvalue, KLM

];

[jegadeesan]

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