Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
Can anyone please tell me how can i suppress these values in pivot table qliksense:
@Aspiring_Developer try below
alt(avg({<Flag={'1'}>}[Avg Hourly Rate]),0)
then uncheck "include zero values" option
Hi,
You can do that by unchecking the include null values checkbox from dimension.
Regards,
Prashant
I did that it is not working because these values are coming because of the measure I am using in the table.
What is the measure you are using?
@Kushal_Chawda avg({<Flag={'1'}>}[Avg Hourly Rate])
@Aspiring_Developer try below
alt(avg({<Flag={'1'}>}[Avg Hourly Rate]),0)
then uncheck "include zero values" option