Box Plot (3 Std Dev)

[kiyap]

Hi everyone,

I am new to Qliksense and have been trying to build a box plot of 3 standard deviation using median. I have tweaked the equations but the title for my tool tip does not appear. Would appreciate any help given! Can anyone tell me where I went wrong?

Name for first whisker:

=if(median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) - 4 *(Stdev( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) ) < Min( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ), 'Minimum', 'Box middle - 4 standard deviations' )

Expression for first whisker:

=Rangemax(median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) - 4 *(Stdev( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) ), Min( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ))

Name for Box Start:

=Rangemax(median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) - 4 *(Stdev( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) ), Min( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ))

Formula for Box Start:

Rangemax(median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) - Stdev( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) , Min( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ))

Name for Center Line:

'Median'

Formula for Center Line:

Median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) )

Name for Box End:

Median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) )

Formula for Box End:

=Rangemin(median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) + Stdev( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) , Max( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ))

Name for Last Whisker:

=if(median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) + 3 *(Stdev( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) ) > Max( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ), 'Maximum', 'Box middle + 3 standard deviations' )

Formula for Last Whisker:

Rangemin(median( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) + 3 *(Stdev( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ) ), Max( total <[Category]> Aggr( Sum(Amount), [Category], [PO_Reference] ) ))

[jladicos]

Unfortunately I don't have a solution, but I'm having a similar issue - I wanted to customize the labels, but when I do, the labels fail to appear at all.