How to get a value with max and if criteria in Qlik Sense?

[Daniel99]

Hi all,

How to get a value with max month and another criteria as below?

=sum(if([CPR_TM1_202202.MONTH]= '2/1/2022' and [CPR_TM1_202202.Business]='CMB', [CPR_TM1_202202.amount]/1000000000))

2/1/2022 is max date in my data set. I want to change '2/1/2022' using the MAX function

any idea?

[Daniel99 · Accepted solution]

ahhh i seee.

really appreciate all solutions from you!

thank you Vitalli!

Regards,

Daniel

[vchuprina]

Welcome! If it's possible please mark correct answers as "solutions".