Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Last Year Sales with Year as Dimension

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

 

1.PNG

And I need this :

2.PNG

 

Sales :  Sum(Sales)

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

 

Thanks for any advice.

Labels (2)
20 Replies
Highlighted
Contributor
Contributor

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

Highlighted

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

Highlighted
Contributor
Contributor

Probably you are right.

Is there another approach I can try?

Highlighted

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?

Highlighted
Contributor
Contributor

Isn't working either.

q2.PNG

Highlighted

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

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

View solution in original post

Highlighted
Contributor
Contributor

Thanks again Sunny, but doesn't work either.

q3.PNG

Highlighted

What version of QV are you on?

Highlighted
Contributor
Contributor

11.00.11271.0 SR1 64-bit

Highlighted

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