Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

eaphymaoweave
New Contributor II

Stacked Bar Chart Set Analysis

Hello community!

I'm trying to build a stacked bar chart that shows the count of the ranking divided by the total count of rankings for a distinct time period. My data is similar to the below. I have a stacked bar chart with time and ranking as dimensions, but i'm struggling to get the measure right. Ideally I would have 3 bars totally to 100% each and the ABC's for each time bar would add up to the 100%.

  

TimeRanking
1A
1A
1B
1C
1C
2A
2B
2B
2B
2C
2C
2A
3A
3A
3A
3A
3B
3A
3A
3C
3B

Any help would be greatly appreciated.

1 Solution

Accepted Solutions

Re: Stacked Bar Chart Set Analysis

May be this

Dimension

Time

Ranking

Expression

Count(Ranking)/Count(TOTAL <Time> Ranking)


Capture.PNG

1 Reply

Re: Stacked Bar Chart Set Analysis

May be this

Dimension

Time

Ranking

Expression

Count(Ranking)/Count(TOTAL <Time> Ranking)


Capture.PNG

Community Browser