topic Re: Suppress when value is null not working in QlikView

Suppress when value is null not working

Tue, 24 Mar 2015 15:17:45 GMT

I have created a pivot table and one of the dimensions is 'Item'. I have checked the 'Suppress when value is null' for this dimension but records are still appearing. How can I get rid of this?? Also, I have item data that contains a + sign in it. I don't want this to show either so how can I get rid of that too????

Here's a screenshot of what it looks like.

javascript:;

Re: Suppress when value is null not working

luciancotea — Tue, 24 Mar 2015 15:23:26 GMT

1) That is empty space, not NULL value.

2) Use TEXT() function to avoid your items being interpreted as using scientific notation.

Re: Suppress when value is null not working

Tue, 24 Mar 2015 15:27:16 GMT

As Lucian says, you have an empty value rather than an actually 'null'.

Have a look at the below for more info on different 'nulls'

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/30/null-the-invisible-nothing

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/02/finding-null

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/28/the-importance-of-nothing

Hope that helps

Joe

Re: Suppress when value is null not working

Tue, 24 Mar 2015 15:28:50 GMT

I am using Text(Item) as Item during the load

Re: Suppress when value is null not working

robert_mika — Tue, 24 Mar 2015 15:40:21 GMT

You can suppressed those values in load statement:

Directory;

LOAD Item,

measure

FROM

[157835.xlsx]

(ooxml, embedded labels, table is Sheet1)

WHERE Item >'

2) You not want this values to be shown or the '+'?

Re: Suppress when value is null not working

Anonymous — Tue, 24 Mar 2015 15:53:41 GMT

In the script change the Item Field to:

If(Len(Trim(Item)) = 0, Null(),Item) as Item

Re: Suppress when value is null not working

Tue, 24 Mar 2015 17:55:27 GMT

Could I put an if condition on the item at the dimension level to take care of the blank space??

What about the scientific notation also????

Re: Suppress when value is null not working

Anonymous — Tue, 24 Mar 2015 18:02:10 GMT

You can try If(Len(Trim(Item)) = 0 or Wildmatch(Item,'*+*'),Null(),Item) as an dimension expression. Not sure if it will work or not.