Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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