Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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
Creator III
Creator III

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

Not applicable

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

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

Creator III
Creator III

In the script change the Item Field to:

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

Not applicable

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

Creator III
Creator III

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