Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Null in totals row?

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.