topic Boxplot expressions and etc. in QlikView

Boxplot expressions and etc.

cmano — Thu, 22 Sep 2022 14:52:18 GMT

Hello guys.

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

The results of the measurements (sample) below:

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.

cmano — Wed, 28 Sep 2022 12:37:24 GMT

Hello guys. I have start built something.

Here is the new data :

For the reference :

Y axis: the measurements

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

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))

Any ideas?

Best regards.

cmano — Wed, 28 Sep 2022 16:45:02 GMT

Maybe better