heirarchy in one column

[#1]

HI,

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

Please help ...

Thanks in advance

Actaul DATA

India North East Zone Ahmedabad Region Ahmedabad Dist Ahemadabad[Territory] India North East Zone Ahmedabad Region Ahmedabad Dist Anand[Territory] India North East Zone Ahmedabad Region Ahmedabad Dist Jamnagar[Territory] India North East Zone Ahmedabad Region Ahmedabad Dist Junagarh[Territory] India North East Zone Ahmedabad Region Ahmedabad Dist Mehsana[Territory] India North East Zone Ahmedabad Region Ahmedabad Dist Rajkot[Territory] India North East Zone Ahmedabad Region Baroda Dist Baroda[Territory] India North East Zone Ahmedabad Region Baroda Dist Bhavnagar[Territory] India North East Zone Ahmedabad Region Baroda Dist Navsari[Territory] India North East Zone Ahmedabad Region Baroda Dist Surat[Territory] India North East Zone Ahmedabad Region Jaipur-Dist Bikaner[Territory] India North East Zone Ahmedabad Region Jaipur-Dist Jaipur[Territory] India North East Zone Ahmedabad Region Jaipur-Dist Jodhpur[Territory] India North East Zone Ahmedabad Region Jaipur-Dist Kota[Territory] India North East Zone Ahmedabad Region Jaipur-Dist Kota[Territory] India North East Zone Ahmedabad Region Jaipur-Dist Udaipur[Territory] India North East Zone AP Region Aurangabad Dist Agartala[Territories] India North East Zone AP Region Aurangabad Dist Ahemadabad[Territory] India North East Zone Delhi Region Calicut Dist Ahemadabad[Territory] India North East Zone Delhi Region Calicut Dist Dehradun Pool[Territory] India North East Zone Delhi Region Chandigarh-Dist Amritsar[Territory] India North East Zone Delhi Region Chandigarh-Dist Bhatinda[Territory] India North East Zone Delhi Region Chandigarh-Dist Chandigarh[Territory] India North East Zone Delhi Region Chandigarh-Dist Faridabad[Territory] India North East Zone Delhi Region Chandigarh-Dist Gurgaon[Territory] India North East Zone Delhi Region Chandigarh-Dist Karnal[Territory] India North East Zone Delhi Region Chandigarh-Dist Ludhiana[Territory]

QlikView Output

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]

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..

[Gysbert_Wassenaar]

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

[#3]

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.