Suppressing null values in pivot table qliksense

[Aspiring_Developer]

Hello ,

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

[Prashant_Naik]

Hi,

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

Regards,

Prashant

[Aspiring_Developer]

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

[Kushal_Chawda]

What is the measure you are using?

[Aspiring_Developer]

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

[Kushal_Chawda · Accepted solution]

@Aspiring_Developer try below

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

then uncheck "include zero values" option