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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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])