https://community.qlik.com/t5/Connectivity-Data-Prep/developemnts-of-app/m-p/1919065#M10576 <P>You can achieve this by adjusting the measures used on the dashboard with set analysis&nbsp; modifiers.</P> <P>If your current dashboard&nbsp; expression is SUM(Sales) then you can adjust which years that are taken into the calculation by adding a set modifier like this.</P> <P>SUM(<STRONG>{$&lt;<EM>Year={"&gt;=$(=max(Year)-1)"}</EM>&gt;}</STRONG>Sales)</P> Sat, 16 Apr 2022 09:46:48 GMT Vegar 2022-04-16T09:46:48Z https://community.qlik.com/t5/Connectivity-Data-Prep/developemnts-of-app/m-p/1918745#M10574 <P><SPAN>Whenever user selects&nbsp; any year value from filter pane, in dashboard should display that year and previous year data? how do you achieve it</SPAN></P> Thu, 14 Apr 2022 18:55:58 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/developemnts-of-app/m-p/1918745#M10574 badamsrinivas 2022-04-14T18:55:58Z https://community.qlik.com/t5/Connectivity-Data-Prep/developemnts-of-app/m-p/1919065#M10576 <P>You can achieve this by adjusting the measures used on the dashboard with set analysis&nbsp; modifiers.</P> <P>If your current dashboard&nbsp; expression is SUM(Sales) then you can adjust which years that are taken into the calculation by adding a set modifier like this.</P> <P>SUM(<STRONG>{$&lt;<EM>Year={"&gt;=$(=max(Year)-1)"}</EM>&gt;}</STRONG>Sales)</P> Sat, 16 Apr 2022 09:46:48 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/developemnts-of-app/m-p/1919065#M10576 Vegar 2022-04-16T09:46:48Z