KPI for % change over two dimensions

raivalen — Thu, 22 Aug 2024 15:22:46 GMT

Hi.

I need to insert on my QlikSense Analytics app a KPI that shows the percentage of change between two years with the below data. How can I show the % of change when I select 2 years as dimension filter?

Re: KPI for % change over two dimensions

Sayed_Mannan — Fri, 30 Aug 2024 18:36:58 GMT

if you want to select two different year then you can use alternative dimension here.

but if you want to see %change based on selected year vs last year then see the below expression:-

Num(
(Sum({<Year = {"$(=Max(Year))"}>} Sales) - Sum({<Year = {"$(=Max(Year)-1)"}>} Sales)) /
Sum({<Year = {"$(=Max(Year)-1)"}>} Sales),
'#,##0.00%'
)

I hope this helps.

topic KPI for % change over two dimensions in App Development

KPI for % change over two dimensions

Re: KPI for % change over two dimensions