Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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