Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a chart which contains city name in x-axis like Bangalore, Hyderabad, Chennai,....
But i need to show it as Bangalore-Karnataka, Hyderabad-AP,Chennai-TamilNadu.
like this in the chart only for display in the x-axis.
how can we do this?
Could You be more specific? or post some snapshot?
I dont want the x-axis label to look like in the image Not_Like_This.png.
I want the x-axis label to look like in the image Like_This.png.
Bangalore and hyderabad values comes from the field City
and the Karnataka and AP values comes from the field State.
so how to combine it in the x-axis label.
and i am using Valuelist in the dimension, to select particular dimension based on some condition.
where'd You get Karnataka, AP from?
From the database field State.
Try in the chart dimension, City & ' ' & State.
City & '- ' & State as YourFieldname
and take YourFieldname in your dimension
Hope this helps