Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Same period last year

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)

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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

oknotsen
Master III
Master III

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".

May you live in interesting times!