Same period last year

[#1]

I have a problem on my pivot table, column 4th ( compair between this period current year and this period last year ).

Pls have a look on my attach file. This is an emergency case. Pls help me

I was trying many expression on Qlik community but it's not working for me.

Like this one : Sum({<Year={$(=Year-1)}>}NetSalePerDate)

[Gysbert_Wassenaar · Accepted solution]

SInce you're using Year as a dimension in your pivot table you'll need to modify your script to add an AsOf table to relate periods with their previous periods. See this blog post: The As-Of Table

[#3]

I use "Year=" in my expresssion to prevent Year selection??? So why did it work ?

[oknotsen]

It does not prevent Year selection, but what it does is including ALL the Years in your data set.

What you are effectively doing is using something that we call "Set Analysis". With "year=" you are saying "ignore whatever is selected for Year and instead consider all values part of the selection".