https://community.qlik.com/t5/App-Development/Different-Targets-for-kpi-every-year/m-p/1691831#M52862 <P>Hey everyone,</P><P>i have few kpis that have different predefined targets each year..</P><P>i want to know what is the best method to have different target for KPIs every year..</P><P>Example:</P><P>KPI = 300 days</P><P>Targets for each year:</P><TABLE width="525"><TBODY><TR><TD width="97.6px" height="24px">Year:&nbsp; 2017</TD><TD width="88px" height="24px">2018</TD><TD width="92px" height="24px">2019</TD><TD width="81.6px" height="24px">2020</TD><TD width="164.8px" height="24px">2021</TD></TR><TR><TD width="97.6px" height="45px">Target: 730 days</TD><TD width="88px" height="45px">180&nbsp;days</TD><TD width="92px" height="45px">90&nbsp;days</TD><TD width="81.6px" height="45px">45&nbsp;days</TD><TD width="164.8px" height="45px">20&nbsp;days</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>KPI = 80%</P><P>Targets for each year:</P><TABLE width="525"><TBODY><TR><TD width="97.6px" height="24px">Year:&nbsp; 2017</TD><TD width="88px" height="24px">2018</TD><TD width="92px" height="24px">2019</TD><TD width="81.6px" height="24px">2020</TD><TD width="164.8px" height="24px">2021</TD></TR><TR><TD width="97.6px" height="45px">Target: 70%</TD><TD width="88px" height="45px">77%</TD><TD width="92px" height="45px">85%</TD><TD width="81.6px" height="45px">89%</TD><TD width="164.8px" height="45px">91%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Currently i can only use 1 target in the color expression...</P> Sat, 16 Nov 2024 18:48:54 GMT Alarkis 2024-11-16T18:48:54Z https://community.qlik.com/t5/App-Development/Different-Targets-for-kpi-every-year/m-p/1691831#M52862 <P>Hey everyone,</P><P>i have few kpis that have different predefined targets each year..</P><P>i want to know what is the best method to have different target for KPIs every year..</P><P>Example:</P><P>KPI = 300 days</P><P>Targets for each year:</P><TABLE width="525"><TBODY><TR><TD width="97.6px" height="24px">Year:&nbsp; 2017</TD><TD width="88px" height="24px">2018</TD><TD width="92px" height="24px">2019</TD><TD width="81.6px" height="24px">2020</TD><TD width="164.8px" height="24px">2021</TD></TR><TR><TD width="97.6px" height="45px">Target: 730 days</TD><TD width="88px" height="45px">180&nbsp;days</TD><TD width="92px" height="45px">90&nbsp;days</TD><TD width="81.6px" height="45px">45&nbsp;days</TD><TD width="164.8px" height="45px">20&nbsp;days</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>KPI = 80%</P><P>Targets for each year:</P><TABLE width="525"><TBODY><TR><TD width="97.6px" height="24px">Year:&nbsp; 2017</TD><TD width="88px" height="24px">2018</TD><TD width="92px" height="24px">2019</TD><TD width="81.6px" height="24px">2020</TD><TD width="164.8px" height="24px">2021</TD></TR><TR><TD width="97.6px" height="45px">Target: 70%</TD><TD width="88px" height="45px">77%</TD><TD width="92px" height="45px">85%</TD><TD width="81.6px" height="45px">89%</TD><TD width="164.8px" height="45px">91%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Currently i can only use 1 target in the color expression...</P> Sat, 16 Nov 2024 18:48:54 GMT https://community.qlik.com/t5/App-Development/Different-Targets-for-kpi-every-year/m-p/1691831#M52862 Alarkis 2024-11-16T18:48:54Z