topic Re: Dimension to include Target for maximum date in QlikView

Dimension to include Target for maximum date

helen_pip — Fri, 27 Jan 2017 16:20:44 GMT

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

Re: Dimension to include Target for maximum date

sunny_talwar — Fri, 27 Jan 2017 16:26:08 GMT

May be like this: (Expression)

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

Re: Dimension to include Target for maximum date

helen_pip — Sun, 29 Jan 2017 16:12:38 GMT

Thank you SunnyT

This provided me with what I required

Thanks

Helen