Monthly Comparison

[#1]

Hi All

I have a scenario where I'm trying to determine company headcount in two different ways.

Firstly I have created a straight table to sum Headcount by Occupation. Now in order for the Headcount sum to make sense, I have to always have one month selected as I don't want to sum everything but only want to see what was the Headcount in each respective month. I have achieved this by enabling "Always one selected value" for the Month field.

Secondly I have created a bar chart  to sum total Headcount by Occupation and Month. In this bar chart, I would like to be able to compare multiple months but cannot do that because of enabling  "Always one selected value" to achieve my previous requirement.

How can I go about achieving both these requirements without affecting each other? Please see attached documents

[#2]

Hi,

see attached QVW if it suits your requirement.

[#3]

sorry you want to compare these months ...not show their summations.

[#4]

Hi

I don't prefer using set analysis because I would like this selection to be flexible (able to select one month only, or 2, 3...etc). Set analysis makes it static.

[settu_periasamy]

Hi,

You can try this expression..

Sum({<[Headcount Date]=,HeadCountMonth=>}[Head Count])

or

Sum({1}[Head Count])

[#6]

Yes I would like to compare them in the bar chart

[robert_mika · Accepted solution]

Another way woudl be to use alternate states.

One listbox for straight table and another one for the bar chart.

Feeling Qlikngry?

How To /Missing Manual(24 articles)

[PradeepReddy]

Sum({1}[Head Count])

[#9]

You can use stacked bar chart like attached.

[#10]

Hi Robert

Thanks! Alternate states will work perfectly.