Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

2-D Bar Graph

Hi Folks, I need to create 2 Dimensional (2D) Bar graph and please find the attched JPEG file reference.

Please share your thougts how can I create this type of charts.

Thanks,

Siri

1 Solution

Accepted Solutions

Re: 2-D Bar Graph

Create a bar chart with three dimensions and one expression.

The first dimension is the one with the values Business Support, Chemical, CMP etc.

The second dimension is the one with the values 0-90, 91-180 and >180

The third dimension is the same as the second. This dimension must be added twice to the chart. Use Add Calculated Dimension to add this dimension the second time.

The expression is whatever measure you want to calculate and display as the bar height.

Here's an example:

comm72269.png

Edit: Without the third dimension you'll only see the labels of the first dimension on the x-axis. Just try with and without it and you'll see the difference.


talk is cheap, supply exceeds demand
2 Replies

Re: 2-D Bar Graph

Create a bar chart with three dimensions and one expression.

The first dimension is the one with the values Business Support, Chemical, CMP etc.

The second dimension is the one with the values 0-90, 91-180 and >180

The third dimension is the same as the second. This dimension must be added twice to the chart. Use Add Calculated Dimension to add this dimension the second time.

The expression is whatever measure you want to calculate and display as the bar height.

Here's an example:

comm72269.png

Edit: Without the third dimension you'll only see the labels of the first dimension on the x-axis. Just try with and without it and you'll see the difference.


talk is cheap, supply exceeds demand
Not applicable

Re: 2-D Bar Graph

Thanks Gysbert and can you explain briefly how 3rd Dimension will effetc the graph visulization.

Community Browser