Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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])