Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null in totals row?

Can anyone tell me why a null would be displaying in the totals row when all the fields have data that the column is referencing?

The work order closure rate expression is set as "([Total Closed Work Requests]/[Total Opened Work Requests])" in my table.

Total opened and total closed columns all have a values and each of the closure rates for the individual have a closure rate as well, why would the totals be null when it should be 69/58 = 119% ?

null_field.png

1 Reply
Not applicable
Author

Fixed this as well, no idea what the problem was but I just added a new measure with the same expression and it shows the correct percentage in the total column.