topic Suppressing null values in pivot table qliksense in App Development

Suppressing null values in pivot table qliksense

Aspiring_Developer — Tue, 01 Sep 2020 16:14:24 GMT

Hello ,

Can anyone please tell me how can i suppress these values in pivot table qliksense:

Prashant_Naik — Tue, 01 Sep 2020 16:26:50 GMT

Hi,

You can do that by unchecking the include null values checkbox from dimension.

Regards,

Prashant

Aspiring_Developer — Tue, 01 Sep 2020 18:14:03 GMT

I did that it is not working because these values are coming because of the measure I am using in the table.

Kushal_Chawda — Tue, 01 Sep 2020 20:24:16 GMT

What is the measure you are using?

Aspiring_Developer — Wed, 02 Sep 2020 11:29:24 GMT

@Kushal_Chawda avg({<Flag={'1'}>}[Avg Hourly Rate])

Kushal_Chawda — Wed, 02 Sep 2020 14:40:34 GMT

alt(avg({<Flag={'1'}>}[Avg Hourly Rate]),0)

then uncheck "include zero values" option