Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Box Plot not graphing as expected

Any help is appreciated.


Quick explanation of my data.

Customer

Acme

Bean
Crimson
Deloitte
Segment
Lumber
Roofing

Stone

so_id

1

2
3
4
5

These are the main tables. I want to use a box plot, to plot a selected company against the performance of their given industry Segment. For example, Bean would be in the Lumber industry.


Performance in this case is # of lines per so_id. For each so_id, such as so_id 1, it can appear many times in the data. So I use a count of the so_id, so if 1 appears 13 times, then we call that the # of lines in so_id 1.


Using the box plot wizard, with segment as dimension and aggregator, I use this as the expression count(so_id)/ count(DISTINCT(so_id))

since as said before, I want # of lines per so_id

Then I click median mode, graph, and this comes up.

result.png

Any help?