Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Repeat max Date for Same ID

Try

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

View solution in original post

3 Replies
MVP
MVP

Re: Repeat max Date for Same ID

Try

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

View solution in original post

Re: Repeat max Date for Same ID

May be this:

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


Capture.PNG

Not applicable

Re: Repeat max Date for Same ID

Thank You Both of You.

Great Learning for me.

Regards

Cire