Qlik Community

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
vinieme12
Esteemed Contributor II

Re: Create a bar chart group by column

Script:

CrossTable(USING,Value,2)

LOAD * INLINE [

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)

241981.1.PNG

Stacked Chart

241981.2.PNG

5 Replies
shraddha_g
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.

vinieme12
Esteemed Contributor II

Re: Create a bar chart group by column

Script:

CrossTable(USING,Value,2)

LOAD * INLINE [

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)

241981.1.PNG

Stacked Chart

241981.2.PNG

vinieme12
Esteemed Contributor II

Re: Create a bar chart group by column

Try with

Dimension as

USING

and

Expression as

Count(Worker)

Highlighted
shraddha_g
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)

)

Community Browser