topic Re: Hide rows in straight table based on field value in QlikView

Hide rows in straight table based on field value

matthewp — Wed, 07 Dec 2016 09:05:26 GMT

I have a straight table that I want to hide the rows unless the Flag field is null.

The values in the Flag field can be A, B or NULL ( - ).

How can i do this

HirisH_V7 — Wed, 07 Dec 2016 09:14:09 GMT

You can suppress null() for the particular dimension,

or at presentation tab, -> supress missing or supress zero for your particular columns need to be ticked.

-Hirish

matthewp — Wed, 07 Dec 2016 09:18:45 GMT

I DONT want to suppress null, i want to ONLY show null

tamilarasu — Wed, 07 Dec 2016 09:23:29 GMT

Hello Matthew,

Add below expression in your expression tab.

If(Len(Trim(Flag Field Name))=0,'-',0)

And make sure "Suppress Zero-Values" option is enaled in the presentation tab.

matthewp — Wed, 07 Dec 2016 09:27:44 GMT

I DONT want to suppress nulls, i want to ONLY show nulls

tamilarasu — Wed, 07 Dec 2016 09:29:36 GMT

The above expression will shows the null values and hides remaining values. Have you tried the expression?

matthewp — Wed, 07 Dec 2016 09:37:04 GMT

Yeh it still doesnt show them

Anonymous — Wed, 07 Dec 2016 09:48:43 GMT

Hi,

Please see attached.

Hope it helps!

tamilarasu — Wed, 07 Dec 2016 09:51:29 GMT

The expression is working fine in the below attached file.