Last Year Sales with Year as Dimension

[Facundo]

Hi, I need to show Last Year Sales per Year, but I'm always end with the same result :

And I need this :

Sales :  Sum(Sales)

LY Sales :  Sum({<Year={"$(=Date(Year-1,'YYYY'))"}>} Sales)

Thanks for any advice.

[Facundo]

Yes, I didn't modify the solution provided before and that property is selected.

[sunny_talwar]

Seems like a QlikView version issue... may be try to upgrade to a newer version of QlikView client

[Facundo]

Probably you are right.

Is there another approach I can try?

[sunny_talwar]

Change your Year dimension to =Aggr(Year, Year) and check 'Suppress When Value Is Null'. I have implemented it in the attached sample... can you check it out?

[Facundo]

Isn't working either.

[sunny_talwar · Accepted solution]

Oh yes, my bad, forgot to change the expression... try this expression

Aggr(Above(Sum({<Year=>}Sales)), Country, Year)

[Facundo]

Thanks again Sunny, but doesn't work either.

[sunny_talwar]

What version of QV are you on?

[Facundo]

11.00.11271.0 SR1 64-bit

[sunny_talwar]

Wow this is old... not sure I can help you find a solution with this version. Updating would be your best bet.