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

Not show rows with Null in straight table?

Hello;

How can I make Qlikview not show rows that contain null in the straight table? Can't find the option in properties!

In table object, There is "Omit Rows Where Field is NULL" in presentation properties, but I'm using a straight table and can't find the same option

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Oh yea below works

If((Len(Trim(Exp1)) > 0 and Len(Trim(Exp2)) )> 0, Exp1)

If((Len(Trim(Exp1)) > 0 and Len(Trim(Exp2)) )> 0, Exp2)

View solution in original post

4 Replies
sunny_talwar

How many expressions are you using here?

You will have to force null all the expressions where they are not getting null. For example, if you have two expressions and you want to exclude null rows for both of them, then you need to use this:

If(Len(Trim(Exp1)) > 0, Len(Trim(Exp2)) > 0, Exp1)

If(Len(Trim(Exp1)) > 0, Len(Trim(Exp2)) > 0, Exp2)

Not applicable
Author

Hey Sunny

Thanks, I have two expressions so should be ok

Are you sure the above works? it gives me -1 for all cells in the table...

Not applicable
Author

Oh yea below works

If((Len(Trim(Exp1)) > 0 and Len(Trim(Exp2)) )> 0, Exp1)

If((Len(Trim(Exp1)) > 0 and Len(Trim(Exp2)) )> 0, Exp2)

sunny_talwar

I am glad that it worked, but I am not sure that how putting an extra parenthesis around the If logic made it worked. I think you might have missed something else and it would have worked without those extra parenthesis as well. Personally I prefer to make my expression as uncluttered as possible so that its easy to decipher for others.

Best,

Sunny