Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

heirarchy in one column

HI,

Can we put all the dimensions of a heirarchy in one column ???

Please help ...

Thanks in advance

Actaul DATA
IndiaNorth East ZoneAhmedabad RegionAhmedabad DistAhemadabad[Territory]
IndiaNorth East ZoneAhmedabad RegionAhmedabad DistAnand[Territory]
IndiaNorth East ZoneAhmedabad RegionAhmedabad DistJamnagar[Territory]
IndiaNorth East ZoneAhmedabad RegionAhmedabad DistJunagarh[Territory]
IndiaNorth East ZoneAhmedabad RegionAhmedabad DistMehsana[Territory]
IndiaNorth East ZoneAhmedabad RegionAhmedabad DistRajkot[Territory]
IndiaNorth East ZoneAhmedabad RegionBaroda DistBaroda[Territory]
IndiaNorth East ZoneAhmedabad RegionBaroda DistBhavnagar[Territory]
IndiaNorth East ZoneAhmedabad RegionBaroda DistNavsari[Territory]
IndiaNorth East ZoneAhmedabad RegionBaroda DistSurat[Territory]
IndiaNorth East ZoneAhmedabad RegionJaipur-DistBikaner[Territory]
IndiaNorth East ZoneAhmedabad RegionJaipur-DistJaipur[Territory]
IndiaNorth East ZoneAhmedabad RegionJaipur-DistJodhpur[Territory]
IndiaNorth East ZoneAhmedabad RegionJaipur-DistKota[Territory]
IndiaNorth East ZoneAhmedabad RegionJaipur-DistKota[Territory]
IndiaNorth East ZoneAhmedabad RegionJaipur-DistUdaipur[Territory]
IndiaNorth East ZoneAP RegionAurangabad DistAgartala[Territories]
IndiaNorth East ZoneAP RegionAurangabad DistAhemadabad[Territory]
IndiaNorth East ZoneDelhi RegionCalicut DistAhemadabad[Territory]
IndiaNorth East ZoneDelhi RegionCalicut DistDehradun Pool[Territory]
IndiaNorth East ZoneDelhi RegionChandigarh-DistAmritsar[Territory]
IndiaNorth East ZoneDelhi RegionChandigarh-DistBhatinda[Territory]
IndiaNorth East ZoneDelhi RegionChandigarh-DistChandigarh[Territory]
IndiaNorth East ZoneDelhi RegionChandigarh-DistFaridabad[Territory]
IndiaNorth East ZoneDelhi RegionChandigarh-DistGurgaon[Territory]
IndiaNorth East ZoneDelhi RegionChandigarh-DistKarnal[Territory]
IndiaNorth East ZoneDelhi RegionChandigarh-DistLudhiana[Territory]
QlikView Output
IndiaNorth East ZoneAhmedabad RegionAhmedabad DistAhemadabad[Territory]
Anand[Territory]
Jamnagar[Territory]
Junagarh[Territory]
Mehsana[Territory]
Rajkot[Territory]
Baroda DistBaroda[Territory]
Bhavnagar[Territory]
Navsari[Territory]
Surat[Territory]
Jaipur-DistBikaner[Territory]
Jaipur[Territory]
Jodhpur[Territory]
Kota[Territory]
Kota[Territory]
Udaipur[Territory]
AP RegionAurangabad DistAgartala[Territories]
Ahemadabad[Territory]
Delhi RegionCalicut DistAhemadabad[Territory]
Dehradun Pool[Territory]
Chandigarh-DistAmritsar[Territory]
Bhatinda[Territory]
Chandigarh[Territory]
Faridabad[Territory]
Gurgaon[Territory]
Karnal[Territory]
Ludhiana[Territory]
Requirement
India
North East Zone
Ahmedabad Region
Ahmedabad Dist
Ahemadabad[Territory]
Anand[Territory]
Jamnagar[Territory]
Junagarh[Territory]
Mehsana[Territory]
Rajkot[Territory]
Baroda Dist
Baroda[Territory]
Bhavnagar[Territory]
Navsari[Territory]
Surat[Territory]
Jaipur-Dist
Bikaner[Territory]
Jaipur[Territory]
Jodhpur[Territory]
Kota[Territory]
Kota[Territory]
Udaipur[Territory]
AP Region
Aurangabad Dist
Agartala[Territories]
Ahemadabad[Territory]
Delhi Region
Calicut Dist
Ahemadabad[Territory]
Dehradun Pool[Territory]
Chandigarh-Dist
Amritsar[Territory]
Bhatinda[Territory]
Chandigarh[Territory]
Faridabad[Territory]
Gurgaon[Territory]
Karnal[Territory]
Ludhiana[Territory]

Hi first table is the actual Data, then what I am getting after using pivot table in qlikview, last one is my requirement. Also I have attached the same as excel.

Please help..

2 Replies
Gysbert_Wassenaar

Yes, it's possible. See the Location field in the attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks for the reply , But all the Regions/district should not come together, one region below that one coresponding district then all the territories of that district then next district ..... etc.. only leave node dimension values will come together.