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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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