Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
gkcchowdary
Contributor

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
Highlighted
shiveshsingh
Honored Contributor

Re: what is year over year?

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?