Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar graph, bar formation question.

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)

barchar.png

11 Replies
Digvijay_Singh

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

Not applicable
Author

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.