topic Re: How to create a Bar Chart with more than one Dimension, Expression in QlikView

How to create a Bar Chart with more than one Dimension, Expression

pashok75 — Mon, 26 Oct 2015 06:06:37 GMT

Dear All,

I am having a challenge of presenting the data in a chart with more than one dimension, expression. Qlik is only showing only one dimension If I show in Bar Chart.

The data will be like this

Year Month Quantity Amount

2012 Jan 50 5000

2012 Feb 60 10000

2012 Mar 70 15000

2013 Jan 50 5000

2013 Feb 60 10000

2013 Mar 70 15000

2014 Jan 50 5000

2014 Feb 60 10000

2014 Mar 70 15000

In pivot table its possible. But I want this as a Bar Chart or an appropriate chart.

Qty Amount Qty Amount Qty Amount

2012

Jan Feb Mar

Qty Amount Qty Amount Qty Amount

2013

Jan Feb Mar

Qty Amount Qty Amount Qty Amount

2014

Jan Feb Mar

Regards,

Ashok

Re: How to create a Bar Chart with more than one Dimension, Expression

Mon, 26 Oct 2015 15:51:11 GMT

one option would be to build a deimension that is the month and year - not sure about the expression without further inforamtion

can you provide a qvw of what you have so far

Re: How to create a Bar Chart with more than one Dimension, Expression

srchilukoori — Mon, 26 Oct 2015 20:32:09 GMT

Hi,

If you use two dimensions and expressions, the bar chart is formatted as a stacked chart. And since the Quantity is very less as compared to the Amount numbers, you are not able to see the two bars as shown in the attached qvw. The alternatives are to use two separate bar charts or split axes or merge the dimensions of year and date as suggested by Adam.

Re: How to create a Bar Chart with more than one Dimension, Expression

PradeepReddy — Tue, 27 Oct 2015 11:37:36 GMT

If your dimensions are Year and Month, then create drill down/cyclic group using these 2 dimensions.

Take Combo Chart, instead of Bar chart. Here you are showing 2 different measures, split the 2 axis..

see the attachment

Re: How to create a Bar Chart with more than one Dimension, Expression

sasikanth — Tue, 27 Oct 2015 13:19:29 GMT

Hi ,

one more option Available Go with Month-Year i.e. APR-2014 like that

Just concatenate two fields YEAR and MONTH YEAR&'-'&MONTH in Dimension

please Find the Below application