topic Re: Expression question in QlikView

Expression question

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the attached data and I would like to only show exceptions where the first entry (by ClOrdID and SendingTime) is Inactive (OrderState).

Is this possible? Examples of this are ClOrdIDs 877251830 and 899963115.

Thanks

Daniel

Gysbert_Wassenaar — Wed, 10 Aug 2016 12:26:52 GMT

I would like to only show exceptions

Exceptions of what?

danielnevitt — Wed, 10 Aug 2016 12:37:04 GMT

I would like to show where the OrderState for a unique ClOrdID is only Inactive or Withdrawn.

In the below data, 777302363 is entered as Inactive at 14:10 and then Withdrawn at 14:17.

Whereas 354438837 and 948801833 where entered as Active and then made Inactive/Consummated.

I would like the expression to be set to only show me scenarios like 777302363.

Thanks,

Daniel

Gysbert_Wassenaar — Wed, 10 Aug 2016 12:49:07 GMT

See attached example

danielnevitt — Wed, 10 Aug 2016 12:52:54 GMT

Thanks for the response Gysbert. Is that the correct example?

I'm slightly unsure how to relate this to my data?

Regards,

Daniel

Gysbert_Wassenaar — Wed, 10 Aug 2016 13:01:31 GMT

No, it wasn't. Fixed now.