Skip to main content

Qlik

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 at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.

263 Views
0 Likes
0 Replies