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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
gkcchowdary
Creator
Creator

what is year over year?

Hi

what is year over year.and what is the use of this and write the set expressions.

Thanks

Chaitanya

1 Reply
shiveshsingh
Master
Master

This means how much you progress in current year than previous year

like (sales of 2018 - sales of 2017)/sales of 2017

expression would be like

=((sum({$<Year = {$(=max(Year))}>}Sales) - sum({$<Year ={$(=max(Year)-1)}>}Sales))/ sum({$<Year = {$(=max(Year)-1)}>}Sales)) * 100


Are you looking for this?