topic Re: Using IsNull Formatting Rule in NPrinting in Qlik NPrinting

Using IsNull Formatting Rule in NPrinting

kdmarkee — Thu, 12 Dec 2019 19:52:05 GMT

I'm using a table loaded in my Levels node for a pixel perfect report, my detail band is using that level, and I am trying to conditionally hide a field in that detail band if the field is null (ie... IsNull([CH334_Level.Reason Code]))but cannot seem to get it working. What am I missing here? Thanks.

Re: Using IsNull Formatting Rule in NPrinting

Lech_Miszkiewicz — Thu, 12 Dec 2019 23:59:23 GMT

Hi Kris,

I am not sure If I understand ... what do you mean by: I am trying to conditionally hide a field in that detail band if the field is null (ie... IsNull([CH334_Level.Reason Code]))?

First of all to use conditional formatting rule you need to have field in the band where condition is applied, then you can make font, borders colours formatting based on value, but I dont think you can actually exclude column as the actual condition seems to be evaluated on row-by-row basis

Re: Using IsNull Formatting Rule in NPrinting

Ruggero_Piccoli — Mon, 27 Jan 2020 09:43:05 GMT

Hi,

It could be that null values are interpreted as empty strings. Try to modify the formula like:

IsNull([CH334_Level.Reason Code])) Or [CH334_Level.Reason Code] == ""

Best Regards,

Ruggero