Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
patrou38
Creator
Creator

Last date as dimension

Hello,

I would like to put as dimension a Date corresponding to the last one (Max(Date(CutOffDate))

but without success.

I tried this expression below, but something is probably missing 🙂

=if(date(CutOffDate)= max(date(CutOffDate)), date(CutOffDate)

Capture.JPG

Thank you for you help.

Patrick

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

=Aggr(if(Date(CutOffDate)= Date(Max( total CutOffDate)), date(CutOffDate), CutOffDate)

View solution in original post

3 Replies
prieper
Master II
Master II

try:

IF(CutOffDate = AGGR(MAX(CutOffDate), CutOffDate), DATE(CutOffDate))

Peter

tresesco
MVP
MVP

Try like:

=Aggr(if(Date(CutOffDate)= Date(Max( total CutOffDate)), date(CutOffDate), CutOffDate)

patrou38
Creator
Creator
Author

Thank you very much, it works 🙂