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: 
QlikSensor
Partner - Creator
Partner - Creator

Box Plot Chart is not displayed because it contains only undefined values

Hi, I am confused. I want to show days per Story points in a box plot. If I use a bar chart, my formula works and shows the bars as I want it to show. But the boxplot says that it can't show due to undefined values.

Here is my formula:

=Sum(([Completed Date]-[Started Date])/[Story Points])

note that "completed date" and "started date" are dates which are computed in days.

1 Reply
Deputy_Dawg
Contributor III
Contributor III

I'm going to have a guess seeing no one else has offered to help you.

Maybe try the interval function. So...

=Sum(Interval([Completed Date]-[Started Date],'d')/[Story Points])