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: 
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.