Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Valued Contributor

Hierarchy in Boxes

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

Hierarchy in Boxes

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
Valued Contributor

Re: Hierarchy in Boxes

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

Hierarchy in Boxes

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

Re: Hierarchy in Boxes

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

Not applicable

Re: Hierarchy in Boxes

Hi,

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

Plz help

Regards

Not applicable

Re: Hierarchy in Boxes

make sure you have extensions installed.

Not applicable

Re: Hierarchy in Boxes

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

Community Browser