Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

% change in Sales for last 5 years

Hi,

I want to show % change in the Sales for last 5 years in a pivot table across all locations. For all the previous years I compare data from Jan to Dec. But for Current Year (2015) I would like to compare Data from Jan 2015 - April 2015 to previous Year Jan 2014 -April 2014

Please see the attachment for Detailspercentage change.png

1 Reply

Re: % change in Sales for last 5 years

Maybe like in the attached qvw. But I usually take another approach. See the AsOf table explanation in this document: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
Community Browser