Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-09-28 09:13 AM

How to make Hierarchy In Qlikview

Hi All,

I have a data set as shown below.

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

RegionNameStateNameCityName
NORTHDelhiDelhi
NORTHHaryanaGurgaon
SOUTHPONDICHERRYPondicherry
SOUTHTAMIL NADUChennai
SOUTHTAMIL NADUVillupuram
WESTGUJARATSurat
WESTMaharashtraKalyan-Dombivli (M Corp.)
WESTMaharashtraPune

Please help me.

40,025 Views
10 Replies
Not applicable
‎2015-07-26 09:54 AM
Author

In response to

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

List Box Tree Load.PNG

Regards,

Chaithu

335 Views
0 Likes