Trying to show month on month change

[PaulWilson]

Hi, I'm new to Qlik Sense and I'm trying to find the right logic to do this. In our reporting we take a snapshot of currency positions at month end, I would like to find a way to compare this month end's rate with the previous one to determine the percentage change for use in a heatmap. Any advice on how best to do this?

[brunobertels · Accepted solution]

hi 

here a simple approach 

table:
load * inline [
MonthEnd,FromCurrency,ToCurrency,avgRate
31/01/2022,AUD,CAD,0.88504025
28/02/2022,AUD,CAD,0.88814245
31/01/2022,AUD,CHF,0.66034821
28/02/2022,AUD,CHF,0.66167182
] (delimiter is ',') ;

NoConcatenate
final:
Load
*,

if(previous(ToCurrency)=ToCurrency ,
1 - previous(avgRate)/avgRate ) as %evol

resident table order by ToCurrency,MonthEnd;
drop table table;

table :

[PaulWilson]

Thanks, that seems to have worked!