How to create leaf structure in Qlikview

[#1]

Hi All,

I am facing this issue

Eg:

My table has following data

Name   Login   RoleName

Abc      abcd    test

Abc      abc      test1

Abc      ab      test2

Lmn     lmn      testlmn

Lmn     xyz      testlmn1

I am creating chart in that chart i want below mentioned the output:-

Name       RoleName

Abc          test\test1\test2

Lmn          testlmn\testlmn1

Please help me in this.

[er_mohit · Accepted solution]

Try this script

Table1:

LOAD * INLINE [

    Nam, Login, RoleName

    Abc, abcd, test

    Abc, abc, test1

    Abc, ab, test2

    Lmn, lmn, testlmn

    Lmn, xyz, testlmn1

];

join

load Nam, concat(RoleName,'/') as [Leaf Config]

resident Table1

group by Nam;

Take a table box with below Field

output like this

Nam	Leaf Config
Abc	test/test1/test2
Lmn	testlmn/testlmn1

[kaushiknsolanki]

Try this.

Data:
Load * inline [
Name,   Login,   RoleName
Abc,      abcd,    test
Abc,      abc,      test1
Abc,      ab,      test2
Lmn,     lmn,      testlmn
Lmn,     xyz,      testlmn1
];

Left join
Load Name ,Concat(RoleName,'/') as TreeView
Resident Data group by Name;

Regards,

Kaushik Solanki

[#4]

data:

LOAD * INLINE [

    Name, Login, RoleName

    Abc, abcd, test

    Abc, abc, test1

    Abc, ab, test2

    Lmn, lmn, testlmn

    Lmn, xyz, testlmn1

];

outer join

load Name, concat(RoleName,'/') as new_field

resident data

group by Name;