Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppress when value is null not working

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:;

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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.

View solution in original post

7 Replies
luciancotea
Specialist
Specialist

1) That is empty space, not NULL value.

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

Not applicable
Author

Not applicable
Author

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

robert_mika
Master III
Master III

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 '+'?

Anonymous
Not applicable
Author

In the script change the Item Field to:

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

Not applicable
Author

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????

Anonymous
Not applicable
Author

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.