Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Display Previous year data with year as dimension

Hi,

I would like to create a Bar Chart with  dimension Year  and a measure showing the previous year  sum of  [Value]  meaning  sum({ previous year} [Value])

for example I expect to see for 2019 bar the sum for 2018, for 2018 bar the sum for  2017 and so on. 

I tried many options, but it doesn't work well.
the same worked for me before with other dimensions.

how can this be done? 

 

*I actually need to display the change percentage between the year and the year before,   i was trying to simplify the issue.   

 

Thank you!

 

Labels (2)
10 Replies
Highlighted
Partner
Partner

That's right, the expression only shows previous value.

But you can add actual value.

See example

martinpohl_0-1591080791796.png

and the value in column 2 in above-expression is december value