https://community.qlik.com/t5/App-Development/KPI-within-a-KPI/m-p/1675891#M51369 <P>use set analysis and create your KPIs something like below.&nbsp;</P><P>sales for the current/max year (or selected)&nbsp;Sum({&lt;Year={"$(=Max(Year))"}&gt;}LineSalesAmount)</P><P>sales for the previous year -&nbsp; Sum({&lt;Year={"$(=Max(Year)-1)"}&gt;}LineSalesAmount)</P> Fri, 14 Feb 2020 18:53:01 GMT dplr-rn 2020-02-14T18:53:01Z https://community.qlik.com/t5/App-Development/KPI-within-a-KPI/m-p/1675890#M51368 <P>I have a data of your Fiscal years.&nbsp;</P><P>I need to create a KPI which displays two values. The main one will give the CollectionRate, and the second one the CollectionRate for the year before. When viewing the sheet, when I use the Year filter to select 2017, the values should show 2017 rate along with 2016 rate.&nbsp;</P><P>The year is taken from the patient admission date and the CollectionRate=TotalPayed/TotalCharged</P> Fri, 14 Feb 2020 18:46:41 GMT https://community.qlik.com/t5/App-Development/KPI-within-a-KPI/m-p/1675890#M51368 sharasridhar 2020-02-14T18:46:41Z https://community.qlik.com/t5/App-Development/KPI-within-a-KPI/m-p/1675891#M51369 <P>use set analysis and create your KPIs something like below.&nbsp;</P><P>sales for the current/max year (or selected)&nbsp;Sum({&lt;Year={"$(=Max(Year))"}&gt;}LineSalesAmount)</P><P>sales for the previous year -&nbsp; Sum({&lt;Year={"$(=Max(Year)-1)"}&gt;}LineSalesAmount)</P> Fri, 14 Feb 2020 18:53:01 GMT https://community.qlik.com/t5/App-Development/KPI-within-a-KPI/m-p/1675891#M51369 dplr-rn 2020-02-14T18:53:01Z