topic Re: Not show rows with Null in straight table? in QlikView

Not show rows with Null in straight table?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Not show rows with Null in straight table?

sunny_talwar — Mon, 27 Jun 2016 17:41:55 GMT

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)

Re: Not show rows with Null in straight table?

Mon, 27 Jun 2016 17:45:49 GMT

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

Re: Not show rows with Null in straight table?

Mon, 27 Jun 2016 17:47:15 GMT

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)

Not show rows with Null in straight table?

Re: Not show rows with Null in straight table?

sunny_talwar — Mon, 27 Jun 2016 22:46:55 GMT

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