# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Create a bar chart group by column

WorkerPeriodABCD
12016011100
22016011010
32016010000
42016010011
12016021110
22016021100
32016031110
42016040000

The table above is a simplified sample of the database that i'm using.

I would like to create a bar chart that shows the sum of workers who are using, A, B, C and D.

Could someone tell me the best way to handle this problem?

1 Solution

Accepted Solutions
Esteemed Contributor II

## Re: Create a bar chart group by column

Script:

CrossTable(USING,Value,2)

Worker,Period,A,B,C,D

1,201601,1,1,0,0

2,201601,1,0,1,0

3,201601,0,0,0,0

4,201601,0,0,1,1

1,201602,1,1,1,0

2,201602,1,1,0,0

3,201603,1,1,1,0

4,201604,0,0,0,0

];

Grouped chart:

Dimensions: Period, USING

Expression Sum(Value)

Stacked Chart

5 Replies
Honored Contributor III

## Re: Create a bar chart group by column

Workers using A:

Count({<A = {'1'}>}Worker)

Similarly for others

Not applicable

## Re: Create a bar chart group by column

I would like to create a Bar chart with as dimension A, B, D and count(Worker) as measure.

Esteemed Contributor II

## Re: Create a bar chart group by column

Script:

CrossTable(USING,Value,2)

Worker,Period,A,B,C,D

1,201601,1,1,0,0

2,201601,1,0,1,0

3,201601,0,0,0,0

4,201601,0,0,1,1

1,201602,1,1,1,0

2,201602,1,1,0,0

3,201603,1,1,1,0

4,201604,0,0,0,0

];

Grouped chart:

Dimensions: Period, USING

Expression Sum(Value)

Stacked Chart

Esteemed Contributor II

## Re: Create a bar chart group by column

Try with

Dimension as

USING

and

Expression as

Count(Worker)

Honored Contributor III

## Re: Create a bar chart group by column

Try:

Dimension : Valuelist('A','B','C')

Measure:

Pick(wildmatch(Valuelist('A','B','C'),'A','B','C'),

Count({<A = {'1'}>}Worker),

Count({<B = {'1'}>}Worker),

Count({<C = {'1'}>}Worker)

)