Show as Tree view in List Box

[#1]

Hello All ,

I have below source data in excel sheet

Region	Country	State	City
Region1	Country1	State1	City1
Region1	Country1	State1	City2
Region2	Country2	State3	City3
Region3	Country3	State4	City3

As I need to show above area details in list box but like a treee view

So I did create load script like below

AreaDetails

LOAD

   Region & '/' & Country  & '/' & State & '/' & City AS AreaDetails

FROM AreaDetails.xls

But the main issue is I can only select leaf node but could not select parent node.

Please let me know how to build a logic or configure this list box so that user can select parent node too.

[#2]

Hi,

The way to create that is explained in a document I have written a few weeks ago:

http://community.qlik.com/docs/DOC-4823

Have a nice reading

Fabrice

[#3]

The document is good but doesn't help much in my case.

As you have considered data which has two columns (ParentKey and ChildKey)

but I have raw data without (ParentKey and ChildKey).

Could you please explain me steps considering my source data ?

[#4]

Hi,

Yes you have the ChildKey / Parentkey columns. And you must have to create a hierarchy.

Load your file several times into a single temp table, sth like for example:

temp_Table:

LOAD City as Childkey,

      State as parentkey

FROM ....

LOAD State as Childkey, Country as parentKey FROM ....

etc.

you will get the 2 columns you need. After that, you follow the doc. Instead of reading a file, you will do a IN-MEMORY LOAD.

LOAD .....

Resident temp_Table

...

it should work.

Fabrice