Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] ) ))
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.