topic Filter out non empty field. in Qlik NPrinting

Filter out non empty field.

Anonymous — Fri, 29 Sep 2017 16:44:22 GMT

In the table listed below, I am trying to build a report of estimates that still need to be followed up on. If field Accepted_Est_Date has a value then the estimate no longer needs to be followed up on so I need these filtered out. I am not sure how to do this as every filter I have tried has not worked. Any ideas would be greatly appreciated.

Re: Filter out non empty field.

krishnacbe — Fri, 29 Sep 2017 16:50:47 GMT

If you want to do this in Load Script then you can create a Flag when Accepted_Est_Date is Null.

Try below expression

if(isnull(Accepted_Est_Date) or Len(Accepted_Est_Date)=0,1,0) as Flag

In Chart use this Flag to filter when Flag is 1.

Re: Filter out non empty field.

Anonymous — Fri, 29 Sep 2017 17:40:46 GMT

Thank you so much. That worked beautifully.

Re: Filter out non empty field.

krishnacbe — Fri, 29 Sep 2017 17:47:30 GMT

Good to hear.

Please close the thread by marking the Correct/Helpful Answer.