topic Hierarchy in Boxes in QlikView

Hierarchy in Boxes

Mon, 02 Apr 2012 07:41:11 GMT

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

Hierarchy in Boxes

v_iyyappan — Mon, 02 Apr 2012 10:51:25 GMT

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

Hierarchy in Boxes

Mon, 02 Apr 2012 11:06:42 GMT

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

Re: Hierarchy in Boxes

v_iyyappan — Mon, 02 Apr 2012 11:25:06 GMT

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

Hierarchy in Boxes

Mon, 02 Apr 2012 19:45:44 GMT

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

Re: Hierarchy in Boxes

Mon, 02 Apr 2012 20:48:30 GMT

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

Re: Hierarchy in Boxes

Tue, 03 Apr 2012 03:43:02 GMT

Hi,

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

Plz help

Regards

Re: Hierarchy in Boxes

Tue, 03 Apr 2012 16:07:55 GMT

make sure you have extensions installed.

Re: Hierarchy in Boxes

Wed, 04 Apr 2012 08:19:58 GMT

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