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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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: 
Anonymous
Not applicable
‎2013-06-20 04:44 PM

Hierarchy Load

I have below raw data.

EntityParentValue
USA
150
ConnecticutUSA30
DanburyConnecticut10
SouthburyConnecticut20
TexasUSA90
HoustonTexas40
DallasTexas50
AlabamaUSA30

How can I get a table in QlikView from above raw data to look like below (lowest level entity)

EntityValue
Danbury10
Southbury20
Houston40
Dallas50
Alabama30

Thanks,

Dinesh.

315 Views
0 Likes
0 Replies