topic Calculate of a new KPI doesn't work in App Development https://community.qlik.com/t5/App-Development/Calculate-of-a-new-KPI-doesn-t-work/m-p/809023#M11188 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>there are two tables Price and Payoff. I want to calculate the new KPI PriceCalc like </P><P>if(ConsumptionFrom&lt;=Consumption and Consumption&lt;=ConsumptionTo, BasicRate+EnergyRate*Consumption,-999).</P><P></P><P>I get only the value -999 for all CustomerID and don't know why.</P><P></P><P>Best regards</P></BODY></HTML> Mon, 16 Mar 2015 10:44:39 GMT 2015-03-16T10:44:39Z Calculate of a new KPI doesn't work https://community.qlik.com/t5/App-Development/Calculate-of-a-new-KPI-doesn-t-work/m-p/809023#M11188 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>there are two tables Price and Payoff. I want to calculate the new KPI PriceCalc like </P><P>if(ConsumptionFrom&lt;=Consumption and Consumption&lt;=ConsumptionTo, BasicRate+EnergyRate*Consumption,-999).</P><P></P><P>I get only the value -999 for all CustomerID and don't know why.</P><P></P><P>Best regards</P></BODY></HTML> Mon, 16 Mar 2015 10:44:39 GMT https://community.qlik.com/t5/App-Development/Calculate-of-a-new-KPI-doesn-t-work/m-p/809023#M11188 2015-03-16T10:44:39Z Re: Calculate of a new KPI doesn't work https://community.qlik.com/t5/App-Development/Calculate-of-a-new-KPI-doesn-t-work/m-p/809024#M11189 <HTML><HEAD></HEAD><BODY><P>Try adding ConsumptionFrom and ConsumptionTo as dimensions. There are several values per customer.</P></BODY></HTML> Mon, 16 Mar 2015 10:59:03 GMT https://community.qlik.com/t5/App-Development/Calculate-of-a-new-KPI-doesn-t-work/m-p/809024#M11189 Gysbert_Wassenaar 2015-03-16T10:59:03Z Re: Calculate of a new KPI doesn't work https://community.qlik.com/t5/App-Development/Calculate-of-a-new-KPI-doesn-t-work/m-p/809025#M11190 <HTML><HEAD></HEAD><BODY><P>thanks for your answer. but adding <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ConsumptionFrom and ConsumptionTo as dimensions chances nothing. </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><IMG alt="pic1.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/80832_pic1.PNG" style="height: 348px; width: 620px;" /></SPAN></P></BODY></HTML> Mon, 16 Mar 2015 11:26:58 GMT https://community.qlik.com/t5/App-Development/Calculate-of-a-new-KPI-doesn-t-work/m-p/809025#M11190 2015-03-16T11:26:58Z