Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Creating a stacked bar chart in Qlik Sense.

Suppose a number of calls have been made from different people. Same people can call multiple times as well. I want to know the percent (%) of people calling once, calling twice, calling 3 times and calling four or more times in a single stacked bar chart in Qlik Sense.

     Eg: if  1 person (say 'A') calls once,

               1 person (say 'B') calls twice

               1 person (say 'C') calls 3 times

               2 people (say 'D' & 'E') calls 4 times each

               Then the stacked bar chart should look like

               Once- 20%,Twice-20%, 3 Times- 20%, 4 Times- 40%

I have attached a test Excel sheet below (Where ID= Customer ID making Calls)

And a sample 'Stacked Bar Graph' result image.Calling Status(Edited).png

1 Solution

Accepted Solutions
Highlighted

Something like this?

Capture.PNG

View solution in original post

3 Replies
Highlighted
Specialist II
Specialist II

Highlighted

Something like this?

Capture.PNG

View solution in original post

Highlighted
Partner
Partner

Thanks a lot .. It worked perfectly.. Cheers