Bar Chart shows the second dimension in the x-axis

[udaya_kumar]

Hi,

I have a created a bar chart with 3 dimensions.

I have empID,empNAME,DepartmentNo as the dimensions.

The bar chart shows the DeparttmentNo. at the x-axis and also the empNAME at the x-axis.

but i dont want to show the empNAME at the x-axis.

it should show only the DepartmentNo. at the x-axis.

so how to hide the second dimension in the x-axis by not showing the value of empNAME?

[rajni_batra]

is it necessary to show 3 dimension ? if it is then choose 3d view otherwise prefer some other chart

[udaya_kumar]

Hi rajni,

Yes, i have to use 3 dimensions.

i tried the 3d view, but also the name displays at the x-axis.

[rajni_batra]

This is from Qlikview help file

A chart can display one or more dimensions. The upper limit depends on the actual chart type, the complexity

of the data and the available memory. Pie, line and scatter charts can display a maximum of two

dimensions, bar, block and grid charts three. Radar charts can only display a single dimension, and gauge

charts use no dimensions at all. A funnel chart typically has one to three dimensions. Further dimensions are

ignored.

A chart dimension gets its values from a field which is specified on the Chart Properties: Dimensions page.

i think u should go for some other chart,, or attach some sample data so that we could help u...

[udaya_kumar]

Hi,

thanks for the reply,

I have attached the image with this. please check it.

I want to hide the values which i have marked the values in black color in the chart.

that is the second dimension in the chart, which shows the values at the x-axis.

i dont want to show those values at x-axis. it should be available only on the popup labels.

I need to use bar chart, because i need to use the charts with 3 dimensions.

[rajni_batra]

Hi,

sorry bt seems to be difficult in this way but if possible try to take that filed in expression part if that is possible obviously or see this thread...

http://community.qlik.com/message/150787#150787

Hope to help..:)

[udaya_kumar]

thanks for the suggestion,

but is there any other way to do that?