topic Dynamic Targets for KPIs in QlikView https://community.qlik.com/t5/QlikView/Dynamic-Targets-for-KPIs/m-p/325688#M579331 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have a set of KPIs say (KPI1, KPI2, KPI3) with targets for each KPI each Month. Now If I build a simple line chart to show trend per month with the KPI expressions grouped in a cyclic button and then add another line chart expression for the target say Only(TargetKPI2), then how can I format the expression so that the target line changes&nbsp; whenever you choose a specific KPI? Is there a good syntax I can use?</P></BODY></HTML> Tue, 28 Feb 2012 16:12:33 GMT 2012-02-28T16:12:33Z Dynamic Targets for KPIs https://community.qlik.com/t5/QlikView/Dynamic-Targets-for-KPIs/m-p/325688#M579331 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have a set of KPIs say (KPI1, KPI2, KPI3) with targets for each KPI each Month. Now If I build a simple line chart to show trend per month with the KPI expressions grouped in a cyclic button and then add another line chart expression for the target say Only(TargetKPI2), then how can I format the expression so that the target line changes&nbsp; whenever you choose a specific KPI? Is there a good syntax I can use?</P></BODY></HTML> Tue, 28 Feb 2012 16:12:33 GMT https://community.qlik.com/t5/QlikView/Dynamic-Targets-for-KPIs/m-p/325688#M579331 2012-02-28T16:12:33Z