topic Re: Bar graph, bar formation question. in QlikView

Bar graph, bar formation question.

Mon, 24 Aug 2015 08:27:54 GMT

Hi guys, the following question regarding bar charts. In the example below you can see two different graphs, in the first one I define a bar for the WeekDays of months. Now what I want is the propety of the last bar chart. I want the red and black bar next to each other.

But in the first graph they are stacked, I do not want that.

But I cannot get it right, any suggestions?

Dimensions:

1) TaskPerfWeekDay

2) =if(match(TaskPerfMonth,'Apr','May','Jun','Jul','Aug','Sep','Oct'), TaskPerfMonth)

Re: Bar graph, bar formation question.

kaushiknsolanki — Mon, 24 Aug 2015 09:34:45 GMT

Hi,

Kindly provide your sample data.

Regards,

Kaushik Solanki

Re: Bar graph, bar formation question.

Anonymous — Mon, 24 Aug 2015 09:36:49 GMT

Hi,

Goto Chart properties - style tab and select group radio button under subtype

Re: Bar graph, bar formation question.

Mon, 24 Aug 2015 09:41:27 GMT

There is no such button under subtype. Only grouped and stacked. And it does not affect the chart.

Re: Bar graph, bar formation question.

Anonymous — Mon, 24 Aug 2015 09:43:48 GMT

Hi,

its typo error

Check Grouped button.

Re: Bar graph, bar formation question.

Mon, 24 Aug 2015 09:45:51 GMT

Okay, yes grouped does not change this behaviour.

I have two expresions:

1) =Sum({<operator={'AAA'}>} aggr(sum(total_hours),ac_registr,TaskPerfDay, TaskPerfMonth))/24

2) Sum({<operator={'BBB'}>} aggr(sum(total_hours),ac_registr,TaskPerfDay, TaskPerfMonth))/24

Re: Bar graph, bar formation question.

Anonymous — Mon, 24 Aug 2015 09:49:45 GMT

Hi,

Add an expression,it will work

if expression is already there,select grouped and click apply

Re: Bar graph, bar formation question.

Mon, 24 Aug 2015 09:55:44 GMT

I have other graphs where it does work, as long I have just one dimension. As soon as I add a second diminesion:

=if(match(TaskPerfMonth,'Apr','May','Jun','Jul','Aug','Sep','Oct'), TaskPerfMonth)

The bars do not group anymore...

Re: Bar graph, bar formation question.

kaushiknsolanki — Mon, 24 Aug 2015 09:57:41 GMT

Hi,

Barchart will not group as per your requirement when you have 2 dimensions and 2 expressions.

If you want to achieve the grouping the try to convert the chart into either 1 dimension 2 expression or 2 dimension 1 expression.

Regards,

Kaushik Solanki

Re: Bar graph, bar formation question.

Mon, 24 Aug 2015 10:04:14 GMT

Okay thank you will give it a try

Re: Bar graph, bar formation question.

Digvijay_Singh — Mon, 24 Aug 2015 10:07:55 GMT

Hi,

Check this out, in case your 3rd dimension is stacked up. Seems like this is the way QV works..

Show more than 2 dimensions in a bar chart

Re: Bar graph, bar formation question.

Mon, 24 Aug 2015 11:18:09 GMT

Im not quite getting my desired result. Does anyone have a suggestion how to merge either the dimension or the expresions to one expresion/dimension?

DIMENSIONS:

1) TaskPerfWeekDay

2) =if(match(TaskPerfMonth,'Apr','May','Jun','Jul','Aug','Sep','Oct'), TaskPerfMonth)

EXPRESIONS:

1) =Sum({<operator={'AAA'}>} aggr(sum(total_hours),ac_registr,TaskPerfDay, TaskPerfMonth))/24

2) Sum({<operator={'BBB'}>} aggr(sum(total_hours),ac_registr,TaskPerfDay, TaskPerfMonth))/24

the bars should be grouped on the operator code AAA and BBB.