Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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 (5)
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!