Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

0 Replies