1 Reply Latest reply: Mar 28, 2012 8:46 AM by DanieleC RSS

    Excluding data in a dimension

      Hi

       

      I'm new to qlikview and I'm having trouble with my file.

       

      Can someone please help me? I'm trying to exclude certain date ranges but can't seem to get it right

       

      Dimension:

      Customer Order Number
      Invoice Date
      Delivery Note Date
      Dispatch Date

       

      Expression:
      Quantity

      I need to exclude "Open" Orders, these are the ones with no invoice date and no delivery note date. How to I exclude these lines?

       

      Thanks

      Elisabeth