How to make Hierarchy In Qlikview

[#1]

Hi All,

I have a data set as shown below.

I want to make a tree structure by using Hierarchy  function in QV

RegionName	StateName	CityName
NORTH	Delhi	Delhi
NORTH	Haryana	Gurgaon
SOUTH	PONDICHERRY	Pondicherry
SOUTH	TAMIL NADU	Chennai
SOUTH	TAMIL NADU	Villupuram
WEST	GUJARAT	Surat
WEST	Maharashtra	Kalyan-Dombivli (M Corp.)
WEST	Maharashtra	Pune

Please help me.

[#2]

Hi Abhishek,

When You said like below:

I can make this structure by righting an expression on a list box like this

=RegionName &' /' & StateName & '/' & CityName  and then by checking the Tree View option

But i tried with the same expression as you mentioned it is showing some extra tree and default selection

Give me the possible way to remove the extra tree

Regards,

Chaithu