topic Re: How to create leaf structure in Qlikview in QlikView

How to create leaf structure in Qlikview

Mon, 22 Jul 2013 11:37:45 GMT

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.

Re: How to create leaf structure in Qlikview

er_mohit — Mon, 22 Jul 2013 11:43:52 GMT

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

Re: How to create leaf structure in Qlikview

kaushiknsolanki — Mon, 22 Jul 2013 11:44:19 GMT

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

Re: How to create leaf structure in Qlikview

Mon, 22 Jul 2013 11:52:55 GMT

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;