heirarchy in one column

Tue, 20 Nov 2012 11:02:32 GMT

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]
		AP Region	Aurangabad Dist	Ahemadabad[Territory]
		Delhi Region	Calicut Dist	Ahemadabad[Territory]
			Calicut Dist	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]

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

Re: heirarchy in one column

Gysbert_Wassenaar — Tue, 20 Nov 2012 11:45:22 GMT

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

Re: heirarchy in one column

Tue, 20 Nov 2012 11:55:14 GMT

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.

topic Re: heirarchy in one column in QlikView

heirarchy in one column

Re: heirarchy in one column

Re: heirarchy in one column