topic Re: hierarchy problem in QlikView

hierarchy problem

Wed, 30 Dec 2015 08:42:44 GMT

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

CTR

NLR

KDP

EAST

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

Re: hierarchy problem

Chanty4u — Wed, 30 Dec 2015 10:21:26 GMT

hi,

follow below qvw...in link

hope this helps

Re: hierarchy problem

Anonymous — Wed, 30 Dec 2015 10:31:20 GMT

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?

Re: hierarchy problem

Anonymous — Wed, 30 Dec 2015 10:33:21 GMT

check this as well:

Hierarchy in QlikView

How to make Hierarchy In Qlikview

Hierarchies

Creating Cycle and Drill Groups

Re: hierarchy problem

Wed, 30 Dec 2015 10:39:49 GMT

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)

Re: hierarchy problem

HirisH_V7 — Wed, 30 Dec 2015 11:11:13 GMT

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

Re: hierarchy problem

ahmar811 — Wed, 30 Dec 2015 11:51:33 GMT

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

Re: hierarchy problem

Wed, 30 Dec 2015 12:01:01 GMT

hi Harish ,

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

SETNAME SUBSETNAME

A 1

B 2

C 3

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

Re: hierarchy problem

Peter_Cammaert — Wed, 30 Dec 2015 12:47:42 GMT

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.

Re: hierarchy problem

MarcoWedel — Thu, 31 Dec 2015 02:15:31 GMT

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

Re: hierarchy problem

Peter_Cammaert — Thu, 31 Dec 2015 02:39:54 GMT

Your last technique that displays just possible values can also (and IMHO more easily) be accomplished by checking "Hide Excluded" in ListBox Properties->General.

Re: hierarchy problem

HirisH_V7 — Thu, 31 Dec 2015 03:46:49 GMT

Hi ,

Check this,

Data2:

LOAD * INLINE [

Setname, Subsetname

A, 1

A, 2

A, 3

A, 4

B, 5

B, 6

B, 7

C, 8

C, 9

];

Left join

Data3:

LOAD * INLINE [

Child Values, Subsetname

1.1, 1

1.2, 1

1.3, 1

1.4, 1

2.1, 2

2.2, 2

2.3, 2

2.4, 2

3.1, 3

3.2, 3

3.3, 3

4.1, 4

4.2, 4

5.1, 5

5.2, 5

6.1, 6

6.2, 6

7.1, 7

7.2, 7

8.1,8

8.2,8

9.1,9

9.2,9

];

By using this above data model output will be like this,

Hope this is the output you desired,

PFA,

Thanks,

-HirisH

Re: hierarchy problem

MarcoWedel — Thu, 31 Dec 2015 09:29:18 GMT

‌HI,

this will leave grey space for excluded values.

regards

Marco

Re: hierarchy problem

Peter_Cammaert — Thu, 31 Dec 2015 15:32:45 GMT

You're right, I hadn't thought of the layout aspect.