Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Calculate of a new KPI doesn't work

Hey,

there are two tables Price and Payoff. I want to calculate the new KPI PriceCalc like

if(ConsumptionFrom<=Consumption and Consumption<=ConsumptionTo, BasicRate+EnergyRate*Consumption,-999).

I get only the value -999 for all CustomerID and don't know why.

Best regards

2 Replies

Re: Calculate of a new KPI doesn't work

Try adding ConsumptionFrom and ConsumptionTo as dimensions. There are several values per customer.

Not applicable

Re: Calculate of a new KPI doesn't work

thanks for your answer. but adding ConsumptionFrom and ConsumptionTo as dimensions chances nothing.

pic1.PNG