Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hierarchy in Boxes

Hi All,

Can we display parent child relationship in Text boxes.

Actually i've a Country-->Region--->City kind of relationship in my structure & its needed to be in Text boxes as shown in the file attached.

Plz help

Thanks

8 Replies
v_iyyappan
Specialist
Specialist

Hi,

     The attached document has no value. Do u want drilldown option in textbox? for example

When i click 2011 its display the value {'jan','Feb'.............{'Dec'}} and when i click the Year 2011 Month ' Jan'

It display the value {'1,2.3.4.5.6.---------------------,31'}.

Please clarrify the doubts, and also attach a sample file.

Regards,

Iyyappan

Not applicable
Author

Hi,

Thanks for the reply

Since i cant implement this in Qlikview as yet, so all i can attach is the word document

You can have different Boxes for Countries or Year in ur case, then each country has its Regions or Months in ur case connected by arrows to its respective country

  Country1                                   Country 2

  |          |

  |          |

  |           

Region 1  Region 2

Same for Country 2 as well and so on....

Actually, once i 've the layout then i can think of having drill down etc, for the time being plz help me build this layout

Best Regards

Sorry for sample layout

Plz help

v_iyyappan
Specialist
Specialist

Hi,

     use the expression like this in text object...

     =Concat(DISTINCT Country, ',') &'-------->'&Concat(DISTINCT Region, ',') &'-------->'&Concat(DISTINCT City, ',')

May be its help for u.

Regards,

Iyyappan

Not applicable
Author

Hi,

When i did this i got all the Countries, Regions & cities in one text box,

but i need them in different text boxes. one country in one text box connected by an arrow with the region which is then connected to the cities.

how do i do this

Regards

Not applicable
Author

i think to get close to what you want, you should use the org chart extension

Not applicable
Author

Hi,

yes this is what i need.........but how do i get this......

Plz help

Regards

Not applicable
Author

make sure you have extensions installed.

Not applicable
Author

Hi,

I've installed all the extensions present as .qar files in the Extensions folder but i'm not able to see any chart when i open ur .qvw file but only list boxes.

Can u specify any particular .qar file i should look for or may be missing from my default Extensions folder which i should have so as to open ur file.

Many Thanks

Regards