Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

How to get a use the maximum date of each given year in a set expression

Hi I am looking for the following output

Year  | MaxDate        |  Sales on MaxDate

2020 | 31/03/2020   |   10

2019 | 31/12/2019   |    20

2018 | 31/12/2018   |   30

 

 

I can't get to a formulation/set analysis that allows me to use the maxdate in the set analysis.

Please advice.

Labels (1)
1 Solution

Accepted Solutions

Hi Harsha,

Try like below

Sum({<Date={$(=Chr(39)&Concat(Aggr(Date(Max(Date)),Year),chr(39)&','&chr(39))&chr(39))}>}Sales)

Thanks & Regards,
Mayil Vahanan R

View solution in original post

1 Reply

Hi Harsha,

Try like below

Sum({<Date={$(=Chr(39)&Concat(Aggr(Date(Max(Date)),Year),chr(39)&','&chr(39))&chr(39))}>}Sales)

Thanks & Regards,
Mayil Vahanan R

View solution in original post