Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show as Tree view in List Box

Hello All ,

I have below source data in excel sheet

RegionCountryStateCity
Region1Country1State1City1
Region1Country1State1City2
Region2Country2State3City3
Region3Country3State4City3

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.

3 Replies
Not applicable
Author

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

Not applicable
Author

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 ?

Not applicable
Author

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