Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
annanirvin
Contributor III
Contributor III

Compare specific IDs

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

2 Replies
Anil_Babu_Samineni

Not really sure about your intend

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
shiveshsingh
Master
Master

May be you can ignore it in set expression

<Message -= {'Passed Watch Date'}