max date

[neapicture]

Hello. I can't get any further. I have a table with a field for different ticket ids, a field for states (new, in progress, solved)
and a date field.
I just want to show the date of the oldest new ticket. Only the date should be displayed. Thanks for the help

[Albert_Candelario]

Hello @neapicture,

Thanks for posting.

I wonder if the information shared on - Solved: Get Max Date and Max Value of a ID - Qlik Community - 1095223 might help you on the situation you have described.

Cheers,

Albert

[MarcoWedel · Accepted solution]

Date(Min({$<[a field for states]={'new'}>} [a date field]))