Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

jciamaichela
New Contributor

Filter out non empty field.

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.

Accepted_Estimate_date.png

1 Solution

Accepted Solutions
krishnacbe
Valued Contributor III

Re: Filter out non empty field.

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.

3 Replies
krishnacbe
Valued Contributor III

Re: Filter out non empty field.

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.

jciamaichela
New Contributor

Re: Filter out non empty field.

Thank you so much. That worked beautifully.

krishnacbe
Valued Contributor III

Re: Filter out non empty field.

Good to hear.

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

Community Browser