I would like to ask about the totals row in tables.
It seems the only thing that can be done in QlikSense tables is choosing a total function and, by default, this calculation take into account all row values shown. This means, for example, the avg function will take into account the '0' values.
My question is: is there any way to exclude the '0' values from this calculation?
G'day, another approach is to remember that null values are excluded automatically, so you can convert the '0' values in the table column to nulls with something like this ...
if( value <> 0, value )
The table will now show '-' for all the '0' values, so the average function will now do what you want.
G'day, another approach is to remember that null values are excluded automatically, so you can convert the '0' values in the table column to nulls with something like this ...
if( value <> 0, value )
The table will now show '-' for all the '0' values, so the average function will now do what you want.
