Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Help with box plot and using variables

Any help is appreciated.

I'm trying to create a boxplot that compares a selected company with other companies performance in their same industry segment.

I have created two variables for ease of use, vSO and vSOLines.

vSO value is =count(DISTINCT(so_id)) and vSOLines value is =count(so_id)

For the top box plot I have Fractile({<Customer = , Segment = p(Segment)>}vSOLinesequals/vSOequals,.75) since I want to graph the Lines per SO

I continue this for middle .5, and bottom .25.

However my plot looks like this, all that shows up is the lines.?

image.png

Any ideas?

9 Replies

Re: Help with box plot and using variables

What is vSOLinesequals and vSOequals?

Not applicable

Re: Help with box plot and using variables

SOLines is the number of lines in an order, SO is the number of orders.

the equals is the same variable, I just shortened it for convenience.

Re: Help with box plot and using variables

So they are expression? If that's true then try using them with Aggr() function

Not applicable

Re: Help with box plot and using variables

Aggr? In the Fractile?

This gives me an error in expression

Fractile(Aggr({<Customer = , Segment = p(Segment)>}vSOLinesequals/vSOequals),.75)

Re: Help with box plot and using variables

My friend.... this is not how this would work... ... Would it be possible for you to share a sample or some sample data to help you better?

Not applicable

Re: Help with box plot and using variables

Sadly, I cannot share this data.

However, going off of this post,

Fractile of an expression

I tried to duplicate it but I'm receiving an error that my chart says no data to display.

This is what I have now

Fractile(Aggr(Count([so_id])/count(DISTINCT[so_id]),Segment),.75)

Count(so_id) is the same as counting the lines, and with distinct, it is counting the orders.

Any ideas?

Re: Help with box plot and using variables

I am not asking to share this data... I am asking to mock up data so that we can see what you have.

How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Not applicable

Re: Help with box plot and using variables

Customer

Acme

Bean
Crimson
Deloitte
Segment
Lumber
Roofing

Stone

so_id

1

2
3
4
5

These are the main tables. 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.

I want to view Bean, which is in the Lumber industry, and see it's lines per so_id compared to other companies in the same Segment.

I need this in a box plot view, and am currently struggling.

Re: Help with box plot and using variables

I don't really understand... I am sure someone else can help you better.

Best,

Sunny