Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Contributor II
Contributor II

Re: Stacked bar Chart with Attached List Box

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

Highlighted
Contributor II
Contributor II

Re: Stacked bar Chart with Attached List Box

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
Highlighted
Contributor II
Contributor II

Re: Stacked bar Chart with Attached List Box

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

Highlighted
Contributor II
Contributor II

Re: Stacked bar Chart with Attached List Box

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

Highlighted
Contributor II
Contributor II

Re: Stacked bar Chart with Attached List Box

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