Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
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.


2 Replies
Creator III
Creator III

try Below(sum(Revenue),1)

Not applicable

It worked! Thanks!