How to repeatedly show the latest date in every row

qlikbbguser — Sun, 25 Aug 2024 15:46:11 GMT

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:

Re: How to repeatedly show the latest date in every row

rubenmarin — Sun, 25 Aug 2024 16:18:34 GMT

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')))