6 Replies Latest reply: Nov 22, 2011 7:19 AM by Aissam Boumejjane RSS

    filtering on any value

    Aissam Boumejjane

      Hi Guys,

       

      I have question ,

       

      I want to filter the shipments that are late, but are not caused by our company. I have a comment field in qlikview wherin we describe the what the reason of delay is, e.g.  'problems with customs in Beijing' or 'Dammage goods'. If the field is empty, then the delay is our fault.

       

      Now, I want to translate this in my gauge chart, my expression below is incorrect:

       

      sum(if(NetWorkDays(Date,ArrivalDate)<=TransitTime, 1,0) and [PO NO.: & Comments]>0) / Count(DISTINCT  OrderNo)

       

      How can I filter on comments that contain any text value?

       

      Thanks in advance!

       

      Isam