Dimension to include Target for maximum date

[helen_pip]

Dear Qlikview User

I have a dataset which is set up as follows:

Metric    Date      Target

A           Jan-17      2

A           Feb-17      3

A           Mar-17      2

B           Jan-17      1

B           Feb-17      2

B           Mar-17      1

I would like to bring the Target field in as an expression or dimension but it would have to be for the maximum Date as my pivot table is only showing data for the most up to date month

Could someone kindly guide me on how to write the correct syntax to achieve this for a dimension/Expression

Kind Regards

Helen

[sunny_talwar · Accepted solution]

May be like this: (Expression)

Only({<Date = {"$(=Date(Max(Date), 'MMM-YY'))"}>} Target)

[helen_pip]

Thank you SunnyT

This provided me with what I required

Thanks

Helen