Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creat Sum Last year in standard table

Dear Qlik users,

How can i get the sum last year data in the green marked zone?

SUM This year and last year.jpg

Thanks for all your help.

1 Reply
jolivares
Specialist
Specialist

In this case you have to disregard the year selected, just for experience what is happens, try to make a table with just year and sales.  Your expressions are: Year (dim) and Sum(Sales) (exp).

But try this ones: Year (dim) and Sum({<Year>}Sales) (exp).

You see now, this is set analysis.