Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
twales
Contributor III
Contributor III

Stacked bar Chart with Attached List Box

Hello,

I'm trying to replicate a demo I did in Power BI for about 20 pages, this unfortunately is my requirement for the Qlik demo.  Other than the basic home page this is page 1 and day 1.  All list boxes(checkboxes) should auto connect to all visuals. 

The Qlik visuals are a filter pane list and the bar chart.

The Power BI chart is percentage of males/females for each arm, x-arm, y-percentages stacked.  Legend-male/female colors.  The summary data set is just for show, detail using is in thousands(not all shown).

So given the condensed detailed data set below how do I create this visual properly?

Thanks

Detailed Data:

QlikArmBySexDetail.jpg

 

 

 

 

 

 

 

 

 

Summary data:

QlikArmBySex2.jpg

Power BI Chart with attached List/Check Box:

qlikstackedbar.jpgqlkistackbar2.jpg

 

 

 

 

 

 

 

 

 

2 Solutions

Accepted Solutions
twales
Contributor III
Contributor III
Author

Solution is as follows:

Bar Chart, Vertical stacked, format measures to number, percent. All lists interactive with chart(s).

Dimension: Arm

Measures

Male: (Count({<sex={'Male'}>}sex)/Count({<sex={'Male','Female',''}>}sex))*100&'%')

Female: (Count({<sex={'Female'}>}sex)/Count({<sex={'Male','Female',''}>}sex))*100&'%'

Result:

QlikBarChartDemo2.jpg

 

View solution in original post

twales
Contributor III
Contributor III
Author

The alternative stacked chart is far better, 2 dimensions and 1 measure.

Dims: Arm(segment) and Race

Measure: Count([race]) / Count(TOTAL <[segment]> [race])

Result:

Stacked2Dimensions!Measure.jpg

View solution in original post

3 Replies
twales
Contributor III
Contributor III
Author

Wrong forum the product is Qlik Sense that I'm demoing not Qlik View.

twales
Contributor III
Contributor III
Author

Solution is as follows:

Bar Chart, Vertical stacked, format measures to number, percent. All lists interactive with chart(s).

Dimension: Arm

Measures

Male: (Count({<sex={'Male'}>}sex)/Count({<sex={'Male','Female',''}>}sex))*100&'%')

Female: (Count({<sex={'Female'}>}sex)/Count({<sex={'Male','Female',''}>}sex))*100&'%'

Result:

QlikBarChartDemo2.jpg

 

twales
Contributor III
Contributor III
Author

The alternative stacked chart is far better, 2 dimensions and 1 measure.

Dims: Arm(segment) and Race

Measure: Count([race]) / Count(TOTAL <[segment]> [race])

Result:

Stacked2Dimensions!Measure.jpg