topic Show as Tree view in List Box in QlikView

Show as Tree view in List Box

Tue, 19 Nov 2013 09:24:37 GMT

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.

Tue, 19 Nov 2013 09:29:25 GMT

Hi,

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

Have a nice reading

Fabrice

Tue, 19 Nov 2013 10:04:49 GMT

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 ?

Tue, 19 Nov 2013 11:12:23 GMT

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