Unable to pick max date

[Anonymous]

Dear All,

Attached qvw sample.

I am unable to pick the last date available for the month. (Max Date available of the month)

Need your help.

Regards,

Niky Rathod

[rubenmarin · Accepted solution]

Hi Niky, you can change your expression by:

Aggr(If(Date=Max(TOTAL <Month> Date), Sum(Stock)), Month, Date)

Using aggr inside set analysis is not working.