Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Max Date disregard ID

Hi Everyone,

My Data consist of ID and ACT_DT. Could anyone please help me to achieve the 'Max_ACT_Date' column. Essentially is the maxof ACT date?

I have tried max({1}Act_DT), but it give me the max of date of each row, which is ACT_DT.

Thanks. 

IDACT_DTmax_ACT_Date
11/02/20201/10/2020
21/03/20201/10/2020
31/04/20201/10/2020
41/05/20201/10/2020
51/06/20201/10/2020
61/07/20201/10/2020
71/08/20201/10/2020
81/09/20201/10/2020
91/10/20201/10/2020
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

so use

max({1}total Act_DT)

instead

View solution in original post

2 Replies
Highlighted
Partner
Partner

so use

max({1}total Act_DT)

instead

View solution in original post

Highlighted
Contributor
Contributor

Thank you mate.. It works like Magic 🙂