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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
EMeany
Contributor III
Contributor III

tFilterRow and Boolean values

Hello, 

 

I am trying to use tFilterRow to exclude rows where a Boolean column (isName) is False.  The GUI does not seem to support Boolean relational so I am attempting to use the Advanced mode.  I have tried the following lines in the Advanced editor without success:

 

input_row.isName.compareTo(true)

input_row.isName == true

input_row.isName.equals(true)

 

While testing the issue, i noticed that using:

 

Relational.ISNULL(input_row.isName)? true:input_row.isName.equals(true)

 

Gives me half the output I want (I get the filter output (value is true) but not the reject output (value is false))

What am I doing wrong here?

 

Thank you in advance!

Labels (2)
1 Solution

Accepted Solutions
iamabhishek
Creator III
Creator III

@EMeany - I just tried to re-pro your use case like below and was able to filter out records. Let me know if this is what you are trying to achieve.

Job Layout - 

0683p000009Lyqq.jpg

 

I have two fields as input (isName is defined as bool). Configured tFilterRow like below - 

0683p000009LyXR.jpg

 

And as you could see the output below the rows are filtered accordingly - 

0683p000009Lyqv.jpg

 

View solution in original post

2 Replies
iamabhishek
Creator III
Creator III

@EMeany - I just tried to re-pro your use case like below and was able to filter out records. Let me know if this is what you are trying to achieve.

Job Layout - 

0683p000009Lyqq.jpg

 

I have two fields as input (isName is defined as bool). Configured tFilterRow like below - 

0683p000009LyXR.jpg

 

And as you could see the output below the rows are filtered accordingly - 

0683p000009Lyqv.jpg

 

EMeany
Contributor III
Contributor III
Author

@iamabhishek

 

Thank you for your reply.  For my particular use case I was not able to use the method you suggested (due to a null pointer error). However, I was able to reproduce your job results and have confirmed that tFilterRow works as you suggest.

 

Thank you again for your help.

E