Calculate the previous years sales in the script and use the new field PYSales in your charts:
[Sales Change Example.xls]
(biff, embedded labels, table is [Sheet1$]);
if(previous(ConsolidatedTenant&SalesMall)=ConsolidatedTenant&SalesMall,previous(Sales)) as PYSales
order by ConsolidatedTenant, SalesMall, Year;
drop Table T1;
If you want you can use a preceding load to calculate the Year-on-Year variance percentage in the script too
I would like to know if you could provide a solution for a similar problem I'm having with my Qlik Sense application. I am trying to create a new field of year-over-year growth rates that I could use and manipulate in the data visualization tool independent of the original field.
Your help on this would be much appreciated.