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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

boxplot does not show what I want

Hi

I have some bins with counters and try to create a percentile boxplot from it.

I use the following formula to find the binvalue for my percentile

if(rangesum(above(bincount,1,rowno()))/sum(total <dim> bincount) <= 0.5
and rangesum(above(bincount,1,rowno()))/sum(total <dim> bincount)
+ bincount/sum(total <dim> bincount) > 0.5, binvalue, null)

This finds me the binvalue where my percentile belongs to and only for one bin in the dimension. I can show this value in a table and in a bar chart but in the boxplot I guess it does not work because I get also null values for bins out of the percentile.

I did not find a way to get the binvalue into each row or to have the boxplot ignore null values. I can also not build a max() or sum() value from the above formula.

Thought I could upload my small example but see no button?

Thanks

Jürg

0 Replies