Expression - <> as "Empty"

[#1]

Hey

I have a problem with empty cells. I would like to plot this expression:

count(if(Testserie=1 and R_Z1V1<>'' ,L_Z1V1))

The thing is that I don't want to count the lines without a value... I tried with <>' ' but it doesnt work.

Thank you for your help!!!

Eduardo

[Gysbert_Wassenaar · Accepted solution]

try:

count(if(Testserie=1 and len(trim(R_Z1V1))>0 ,L_Z1V1))

[CELAMBARASAN]

Is it Empty or Null. Null is different from empty.

If it is Null then use in set analysis as

count({<Testserie={1},R_Z1V1-={*}>}L_Z1V1)

other wise

use Gysbert Wassenaar suggestion.