How to repeatedly show the latest date in every row

[qlikbbguser]

hello, 

Could you help with my question:

I want to create an expression that returns the latest date for EACH row.

In my data, 7/1/2024 is the latest date. So in the 'max date test' column shown below - I want to show 7/1/2024 in every single row.  

my current expression of 'max date test' field seems not to be working:

[rubenmarin · Accepted solution]

Hi, you can try with: Date(Max(TOTAL Date#([Qlik Date],'MM/DD/YYYY')))

After TOTAL you can add the dimensions of the table to set the max date by row:

Date(Max(TOTAL <Dim1Field, Dim2Field> Date#([Qlik Date],'MM/DD/YYYY')))