Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

udaya_kumar
Valued Contributor

Add field to the x-axis in the chart only for display

Hi,

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?

Tags (3)
6 Replies
Not applicable

Re: Add field to the x-axis in the chart only for display

Could You be more specific? or post some snapshot?

udaya_kumar
Valued Contributor

Re: Add field to the x-axis in the chart only for display

Hi pari,

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.

Not applicable

Re: Add field to the x-axis in the chart only for display

where'd You get Karnataka, AP from?

udaya_kumar
Valued Contributor

Re: Add field to the x-axis in the chart only for display

From the database field State.

rominavilla
New Contributor III

Re: Add field to the x-axis in the chart only for display

Try in the chart dimension, City & ' ' & State.

Regards.

chauhans85
Esteemed Contributor

Re: Add field to the x-axis in the chart only for display

use below

City & '- ' & State as YourFieldname

in Script

and take YourFieldname in your dimension

Hope this helps

Community Browser