Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
pkelly
Specialist
Specialist

Cum % Sales Movement

Wondering if I could get some advice...

I have been asked to create the attached report in QlikView.

Last Year / This Year and progress are straightforward...

Not sure how I go about "Cum %Sales Movt" and "Cum £GP Movt"...

Any guidance greatly appreciated...

1 Reply
Not applicable

You can calculate any of these values with expressions. You will have to use some range and inter-record functions to get the accumulated values, but you can do it with separate expressions. I have built an example with these calculations in case it could be useful for you.

Juan Gerardo