Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
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...
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)
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