Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Repeat max Date for Same ID

Hi All

I have this Requirement

max Repeat.png

For Better understanding, I have Attached sample qvw.

Regards

Cire

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

=If(Year(Date1)=1900,FirstSortedValue(Total<ID> Date2, -Flag),Date1)

View solution in original post

3 Replies
swuehl
MVP
MVP

Try

=If(Year(Date1)=1900,FirstSortedValue(Total<ID> Date2, -Flag),Date1)

sunny_talwar

May be this:

IF(WildMatch(Date1,'*1900*'),FirstSortedValue(TOTAL <ID> Date2, -Flag),Date1)


Capture.PNG

Not applicable
Author

Thank You Both of You.

Great Learning for me.

Regards

Cire