I have orders data amd I wish to pick Lost Booking $$s for cancelled orders in the dashboard.
The filter is Give me booking $$
where cert_status = INVALID
and order_status in(' REJECTED','CANCELLED')
How I can put this filter in Qlikview
Thank You all in advance
You can create a separate field using inline for this invalid, rejected and cancelled
Retrieving data ...