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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rp1366nc
Contributor
Contributor

YoY Growth in Table Chart

I have try to create a YoY Growth in a table chart.

I try a expression to get the previous year value:

Sum( {<SalesYear=${year(SalesYear)-1}>} SalesAmount )

But the value have no change which same as the current value.

May I know what is the problems?

Thank you.

Labels (1)
2 Replies
rupeshshah888
Contributor
Contributor

Please try:

Sum( {<SalesYear={'$(=year(max(SalesYear))-1)'}>} SalesAmount )

Kushal_Chawda

@rp1366nc  If you have year as dimension set analysis won't work. You need to use above function

=above(sum(SalesAmount))