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

Finding max Date given a criteria

I have a list of dates and each of them is either TypeA or TypeB. I am trying to select the largest (or most recent) date from the list among only the TypeAs.

So far I have been using Date(Max ([X_Date])) but I have not been able to figure out how to select based on a criteria.

What I want is something like Date(Max ([X_Date]) where Category = {'TypeA'}).

Any advice on how this can be achieved?

1 Solution

Accepted Solutions
Not applicable
Author

Hi Dkeresteci,

In a chart you can use set analysis like:

Date(Max({$<Category={TypeA}>}[X_Date])

Regards,

Bert

View solution in original post

3 Replies
its_anandrjs

Hi Dkeresteci,

Do you have any sample file it will going more easy.

Regards,

Anand

Not applicable
Author

Hi Dkeresteci,

In a chart you can use set analysis like:

Date(Max({$<Category={TypeA}>}[X_Date])

Regards,

Bert

Not applicable
Author

Awesome, works great, thanks Bert!