Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
reshma_km
Partner - Creator III
Partner - Creator III

Row Suppression in Qlik sense

Hi,

Suppressing rows requires coding expressions into each dimension. Is there any way for the end user to suppress certain rows, for example, nulls and zeroes other than editing dimension expression?

2 Replies
isingh30
Specialist
Specialist

We do have suppress if value is null option in qlikview but i believe you have to code to suppress in qlik sense.

Like field > 0

devyanshu_gupta
Partner - Contributor III
Partner - Contributor III

Hi,

You can try to filter those values in Measure expression via set analysis

for eg if you want to remove nulls

=Sum({<Dimension-={IsNull}>}Measure)


Regards,

Devyanshu