Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator II
Creator II

Suppressing null values in pivot table qliksense

Hello ,

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

Aspiring_Developer_0-1598976850958.png

 

1 Solution

Accepted Solutions
Kushal_Chawda

@Aspiring_Developer try below

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

then uncheck "include zero values" option

View solution in original post

5 Replies
Prashant_Naik
Partner
Partner

Hi,

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

Regards,

Prashant

Aspiring_Developer
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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

Kushal_Chawda

@Aspiring_Developer try below

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

then uncheck "include zero values" option

View solution in original post