Skip to main content

App Development

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lital
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 (1)
10 Replies
martinpohl
Partner - Master
Partner - Master

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