Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
tizianacaem
Partner - Contributor
Partner - Contributor

Problem with Pivot table

Hello all.
I have a problem with an expressions in pivot table.
In lines of pivot table I have calculated the Sales of CurrentYear and PreviousYear.
If I show the dimension Year in column, is possible to see the data, like the following example?

2009 2010 2011

sales Current Year sales2009 sales2010 sales2011

sales PreviousYear sales2008 sales2009 sales2010

thanks

Tiziana

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

I'd handle it with an "AsOf" table linking an AsOfYear to both the current year and the previous year. See attached.

View solution in original post

2 Replies
johnw
Champion III
Champion III

I'd handle it with an "AsOf" table linking an AsOfYear to both the current year and the previous year. See attached.

tizianacaem
Partner - Contributor
Partner - Contributor
Author

Thank you very much.. it work rightly!!