topic Re: Box plot only showing first value outliers, Urgent Help! in QlikView

Box plot only showing first value outliers, Urgent Help!

Emma — Sat, 16 Nov 2024 21:20:07 GMT

Hi,

I created a box plot to show the distribution of CycleTimes, but when I change its orientation it only shows the outliers for the first row.

The pictures below show the same box plot.

Upper whisker formula:

Max(If([Cycle Time]*60<= Aggr(2.5*Fractile(total <Name> [Cycle Time]*60,0.75) -1.5*Fractile(total <Name> [Cycle Time]*60,0.25), Name, [Cycle Time]*60), [Cycle Time]*60))

Lowe Whisker:

Min(If([Cycle Time]*60>= Aggr(2.5*Fractile(total <Name> [Cycle Time]*60,0.25) -1.5*Fractile(total <Name> [Cycle Time]*60,0.75), Name, [Cycle Time]*60), [Cycle Time]*60))

Only using 1 dimension which is Name (the name of the products).

I have been told that it might be a grain mismatch issue but I am not sure how to resolve it here.

Thank you.

Re: Box plot only showing first value outliers, Urgent Help!

sunny_talwar — Wed, 27 Feb 2019 13:14:25 GMT

You should not have a grain mismatch just for changing the orientation of the chart. Would you be able to share a sample to test this out?

Re: Box plot only showing first value outliers, Urgent Help!

Emma — Wed, 27 Feb 2019 13:33:26 GMT

Hi Sunny,

Thank you for your reply, I created a sample for you.

Both Box plots are the same, the only difference is the orientation. Yet, the outliers disappear for all besides the first row once I make it horizontal.

Many thanks.

Amine

Re: Box plot only showing first value outliers, Urgent Help!

sunny_talwar — Wed, 27 Feb 2019 13:49:25 GMT

This does seem like some kind of a bug. I am seeing the same issue. I think you should reach out to Qlik Support to create a ticket with them.

Re: Box plot only showing first value outliers, Urgent Help!

Emma — Wed, 27 Feb 2019 13:53:03 GMT

I see, thanks!