Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comparing Year to Date This Year with Year to Date Last Year

I have a Straight Table that shows sales values broken down by period for the current financial year and the previous one, and showing accumulated year to date values.

I have now got a % comparison between each period to show the increase/decrease for that period between last year and this year, but what I can't work out is how to show a % comparison in the same way but based on year to date values instead of individual periods.

Is anyone able to suggest the correct expression to use for this please?

An example QVW file is attached to show the sort of thing I mean (can't attach my real one due to the fact that it has confidential data in it).

Any help on this would be much appreciated.

Many thanks.


Andrew

0 Replies