Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
cmano
Creator
Creator

Boxplot expressions and etc.

Hello guys.

I try to create my first boxplot and i have some issues.

The results of the measurements (sample) below: 

Order Mean value Lower specif. limit Upper specif. limit
1 9,5 6,0 16,0
1 14,2 6,0 16,0
1 12,1 6,0 16,0
1 15,3 6,0 16,0
1 13,6 6,0 16,0
1 14,0 6,0 16,0
1 13,5 6,0 16,0
2 12,5 6,0 16,0
2 10,5 6,0 16,0
2 13,1 6,0 16,0
2 12,3 6,0 16,0
2 12,6 6,0 16,0
2 12,3 6,0 16,0
2 10,3 6,0 16,0
2 12,5 6,0 16,0
3 13,5 6,0 16,0
3 15,1 6,0 16,0
3 13,4 6,0 16,0
3 14,6 6,0 16,0
3 10,3 6,0 16,0
3 12,3 6,0 16,0
4 15,1 6,0 16,0
4 15,4 6,0 16,0
4 15,4 6,0 16,0
4 15,4 6,0 16,0
4 15,4 6,0 16,0
5 15,4 6,0 16,0
6 15,4 6,0 16,0
7 15,4 6,0 16,0

 

I want to create a box plot of the Mean values per Order with the limits at the table.

i can not figure out the expressions i must write 

Best regards.

Labels (2)
2 Replies
cmano
Creator
Creator
Author

Hello guys. I have start built something.

Here is the new data :

P.O Des M.V LSL USL
1 γ 9,5 6,0 16,0
1 γ 14,2 6,0 16,0
1 γ 12,1 6,0 16,0
1 γ 15,3 6,0 16,0
1 γ 13,6 6,0 16,0
1 γ 14,0 6,0 16,0
1 γ 13,5 6,0 16,0
1 φ 30,1 28,0 32,0
1 φ 30,2 28,0 32,0
1 φ 30,3 28,0 32,0
1 φ 30,4 28,0 32,0
1 φ 30,5 28,0 32,0
1 φ 30,6 28,0 32,0
1 φ 30,7 28,0 32,0
2 γ 12,5 6,0 16,0
2 γ 10,5 6,0 16,0
2 γ 13,1 6,0 16,0
2 γ 12,3 6,0 16,0
2 γ 12,6 6,0 16,0
2 γ 12,3 6,0 16,0
2 γ 10,3 6,0 16,0
2 γ 12,5 6,0 16,0
2 φ 31,1 28,0 32,0
2 φ 31,2 28,0 32,0
2 φ 31,3 28,0 32,0
2 φ 31,4 28,0 32,0
2 φ 31,5 28,0 32,0
2 φ 31,6 28,0 32,0
2 φ 31,7 28,0 32,0
3 γ 13,5 6,0 16,0
3 γ 15,1 6,0 16,0
3 γ 13,4 6,0 16,0
3 γ 14,6 6,0 16,0
3 γ 10,3 6,0 16,0
3 γ 12,3 6,0 16,0
3 γ 32,1 28,0 32,0
3 φ 31,2 28,0 32,0
3 φ 31,3 28,0 32,0
3 φ 31,4 28,0 32,0
3 φ 31,5 28,0 32,0
3 φ 31,6 28,0 32,0
3 φ 31,7 28,0 32,0
4 γ 15,1 6,0 16,0
4 γ 15,4 6,0 16,0
4 γ 15,4 6,0 16,0
4 γ 15,4 6,0 16,0
4 γ 15,4 6,0 16,0

 

For the reference :

Y axis: the measurements

X axis : P.O per γ (Des)
According to box plot wizard i have create the below chart

Screenshot 2022-09-28 132757.png

Expressions: 

Box Plot Middle

Fractile(Aggr(Fractile(M.V,0.05),[P.O],[M.V]), 0.5)

Box Plot Bottom

Fractile(Aggr(Fractile(M.V,0.05),[P.O],[M.V]), 0.25) 

and etc.

The problem is that in current state the box plate takes all the values from Des.
I want to create two separates box plots one for γ & one for φ.

i have try to add the If function but with no results.

Box Plot Middle

If(Des='φ',Fractile(Aggr(Fractile(M.V,0.05),[P.O],[M.V]), 0.5))

Box Plot Bottom

If(Des='φ',Fractile(Aggr(Fractile(M.V,0.05),[P.O],[M.V]), 0.25))

Screenshot 2022-09-28 134935.png

 

Any  ideas?

Best regards.

cmano
Creator
Creator
Author

Maybe better