Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

thonipad
Contributor III

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.

Community Browser