Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

1 Reply
Not applicable

Excluding data in a dimension

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