Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use the dimension information on set analysis?

I need to make a table with year as dimension, and a column giving the variation from the current year on the row with the past year. I tried to use something like this: =sum({<Year={$(=Year-1)}>} Revenue)   to get the revenue of the last year in the current year row, but I've received only 0's in all rows.

Follow a simple example with what I'm trying to do. The basis are two columns. One with years (2010 to 2014) and revenues. There are 10 rows for each year.

Thanks

2 Replies
arthur_dom
Creator III
Creator III

try Below(sum(Revenue),1)

Not applicable
Author

It worked! Thanks!