Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
BA621858188
Creator
Creator

Blank value using tfilterrow

Hi All,

 

I want to check and filter blank values from a file based on an integer column and using the tfilterrow component. How can I use the tfilter row component properties. Can anyone help me on this?

 

I am doing currently as below:

column - (integer column)

function - empty.

operator - equals

value - ""/'' (this is giving me an error)

 

Appreciate your help.

Labels (4)
20 Replies
rhall1
Contributor III
Contributor III

I'm afraid it is very difficult to help without seeing precisely what is being done. The original question has this in it....

 

I am doing currently as below:

column - (integer column)

function - empty.

operator - equals

value - ""/'' (this is giving me an error)

 

The value leads us to suspect that a String is possible in this column. With an int/Integer a String is not possible. It will not accept "0", "1", "", "a", "b", etc. It will only accept 0, 1, 2, 3, 4, 5....if it is an int (primitive) or 0,1,2,3,4,,...if it is an Integer (,,) is essentially a comma separated null. Null is nothing.

 

This is why I asked for the screenshots. If ""/" was ever supplied to this column, it is not an int/Integer. This may have changed during this discussion, but it is so hard to provide ideas unless we can see the exact config and the exact output.