hierarchy problem

[#1]

My Task is one table  two fields hierarchy processs....

Country                 State      District

INDIA                    AP        CTR

USA                       UP        NLR

UK                          MP       KDP

AUSTRALIA            KA       EAST

1.you select INDIA

2.show AP UP MP KA

3.again select AP THEN SHOW  .......... AP

                                                             UP

                                                             MP

                                                            KA

                                                            CTR

                                                             NLR

                                                             KDP

                                                              EAST

Comes to this way in hierarchy in qlikview processs please help mee any body......

[Chanty4u]

hi,

follow below qvw...in link

hope this helps

[Anonymous]

How do you want?

like this?  Country -> State -> City? In this case create a Drill group of these dim.

what you mentioned is like, Country -> State -> State & City both?

[Anonymous]

check this as well:

Hierarchy in QlikView

How to make Hierarchy In Qlikview

Hierarchies

Creating Cycle and Drill Groups

[#5]

Balraj...thanks

But my task is first select INDIA then comes from INDIA chaild values.

again select  any chaild value of INDIA  come to chaild of chaild values( like Hierarchy)

[HirisH_V7]

Hi ,

Your Data Model Should be like this,

Data:
LOAD * INLINE [
    Country, State, District,Sales
    India, AP, CTR,1
    India, AP, NLR,2
    India, AP2, KDP,3
    India, AP2, East,4
    UK, IR, IO,1
    US, NY, Washington,1
];

Load this data and create a Chart and At dimensions -> Edit Groups -> And create a drill down group with Country - State - District Hierarchy.

Then you can see the State by selecting the country and then by selecting state the district.

PFA,

Hope this helps,

Thanks,

Hirish

[ahmar811]

Hi HARI PRASAD T

try this step

First you need to create data like that

then second write this expression before load

Hierarchy(GEOG_HKEY,PARENT_KEY,GEOG_DESC,[GEO PAR NAME],GEOG_DESC,[HIERARCHY GEO],'/','HIERARCHY PATH')

like that

after this set the properties on field

then your output look like this

hope this help you

Thanks & Regards

Ahmar Ansari

[#8]

hi Harish ,

but one thing i need in script level datamodeling( field names SETNAME AND SUBSETNAME)

SETNAME     SUBSETNAME

A                          1

B                           2

C                            3

                             4

if select SETNAME A-------->it will return 1 2 3 4(CHAILD VALUES)

and agai select SUBSETNAME 1--------> it will return  1 2 3 4 and also  1 chaild values(1.1  1.2  1.3........like this)  in Hierarchy in Qlikview in data modeling

[Peter_Cammaert]

Simple and effective.

Note that Drill-Down groups are not the exclusive property of graphical charts. As Hirish V shows, they can be used in tables as well.

[MarcoWedel]

Hi,

also possible (using hirishv7example):

- straight table with dimension group but without expression:

- List Box

using a group consisting of calculated dimensions to only show possible values:

compared to using a List Box with a dimension group consisting of the fields itself:

hope this helps

regards

Marco