Im using a CQWP and need to display all items that have a column that is empty. The column is a lookup but I've tried a normal (single line of text) column but cqwp shows no filtering for null or empty values.

  • Well, i guess you could try with 0;# as this is the equivalent to a empty lookup column. – Christoffer Dec 4 '15 at 15:21
  • Tried equal 0;# but doesn't work :( – Orange Juice Jones Dec 4 '15 at 16:19

Workaround - create new Calculated column "Display".

Formula should be: =IF(LEN(LookupCol)=0;"Yes";"No").

Eventually, make a filter based on Display column: Show items when Display is equal to Yes.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.