topic Re: Table: avg totals without 0's in App Development

Table: avg totals without 0's

idrb — Tue, 28 Mar 2023 09:57:37 GMT

Hi everyone,

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?

Thanks in advance,

David

Re: Table: avg totals without 0's

Or — Tue, 28 Mar 2023 10:33:24 GMT

Avg({< Values -= {"0"} >} Values)

Re: Table: avg totals without 0's

barnabyd — Tue, 28 Mar 2023 20:41:54 GMT

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.

Cheers, Barnaby.

Re: Table: avg totals without 0's

idrb — Wed, 29 Mar 2023 10:43:01 GMT

Hi,

This solution worked like a charm!

Thank you very much!!

Cheers,

David