topic Re: hierachy issue in QlikView

hierachy issue

vipin_mishra479 — Tue, 07 May 2013 12:30:04 GMT

hi all,

I have a multiple field

eg. order

suborder

material

submaterial,

product,

Amount,

level

and my level is define this way

01.01

01.01.01

01.01.01.02

01.01.01.03

01.02

01.02.01

01.02.02

01.03

01.03.01

02.01

02.01.01

02.02

03.01

03.01.01

03.02

then how to generate a hirarchy using this field "level"

Re: hierachy issue

alexpanjhc — Tue, 07 May 2013 14:13:50 GMT

I'd use Dual() function to get the level and then sort.

dual(

if(level='01',' A', // you can change A to whatever name you want to give'

if(level>'01.01' ,'B',

)),

if(level='01',1, // this is to give you a sort #so that you can sort later on if the level are not numeric.

if(level>'01.01' ,2,

))

)

Re: hierachy issue

vipin_mishra479 — Wed, 08 May 2013 06:04:44 GMT

Thanks for reply alexpanjhc

But i want my level in tree structure

eg.

01 + 01.01

01.02

01.03

00 + 02 + 02.01

02.02

02.03

03 + 03.01

03.02

03.03

Re: hierachy issue

alexpanjhc — Wed, 08 May 2013 14:17:51 GMT

First, I do not see the reason you have a root leave since everyone is under it and you have no value for the root level,

but for others you can do the same thing. create more levels(fields) for your structure.

left(level,2) as top_level, //create a new level for the top level,