topic Re: Compare specific IDs in QlikView

Compare specific IDs

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

Hi.

I have a set of IDs that appear as follows:

NumericCount (DISTINCT{<Message = {'Passed Watch Date'}, BevFlag = {1}, Date = {"$ (= Date (Max (Date) -1)) "}>} ID). I would like to compare these specific IDs to see which of those who do not meet the 'Passed Watch Date' criterion the day after that, ie. Date = {"$ (= Date (Max). Is this possible? I do not want to use alternate states.

Regards

Anna

Re: Compare specific IDs

Anil_Babu_Samineni — Tue, 22 May 2018 03:04:24 GMT

Not really sure about your intend

ie. Date = {"$ (= Date (Max). Is this possible? I do not want to use alternate states.

Re: Compare specific IDs

shiveshsingh — Tue, 22 May 2018 03:15:53 GMT

May be you can ignore it in set expression

<Message -= {'Passed Watch Date'}