Excluding data in a dimension

[#1]

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

[#2]

Hello Elizabeth,

  go to the dimension option of your table or chart and thick "suppress when value is null" on invoice date and delivery note date.

Regards,

Daniele