topic Row Suppression in Qlik sense in App Development

Row Suppression in Qlik sense

reshma_km — Fri, 08 Jun 2018 14:13:20 GMT

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?

Re: Row Suppression in Qlik sense

isingh30 — Fri, 08 Jun 2018 16:06:23 GMT

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

Re: Row Suppression in Qlik sense

devyanshu_gupta — Mon, 11 Jun 2018 12:08:50 GMT

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