Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Emma
Contributor II
Contributor II

Box plot only showing first value outliers, Urgent Help!

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.

l.PNGCapture.PNG

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.

Labels (1)
4 Replies
sunny_talwar

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?

Emma
Contributor II
Contributor II
Author

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

sunny_talwar

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.

Emma
Contributor II
Contributor II
Author

I see, thanks!