topic max date in QlikView

max date

neapicture — Mon, 28 Feb 2022 13:06:51 GMT

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

Re: max date

Albert_Candelario — Mon, 28 Feb 2022 14:59:07 GMT

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

Re: max date

MarcoWedel — Mon, 28 Feb 2022 19:39:23 GMT

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