Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
shatrix
Contributor
Contributor

Last Year Sales doesn't work

Hi

Selected year sales is  : 

Sum({< Year={$(=max(Year))}>}QTY_KG)

returns the right values , works fine. 

 

While last year sales is :

Sum({<Year= {$(=max(year)-1)}>}QTY_KG)/1000

It only displays the current year QTY_KG !

Both lines return the same values !

 

How can I  fix that ? What's wrong with the syntax ?

 

2 Replies
menta
Partner
Partner

Check the Year and year.

Check if you use selections or dimension in table like year-month

shatrix
Contributor
Contributor
Author

Tried year and Year . the same.

I don't use dimensions in table like year month, just customer name. 

What do you mean if I use selections ? Year is selected (happens with every year I select).