Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Try adding ConsumptionFrom and ConsumptionTo as dimensions. There are several values per customer.
thanks for your answer. but adding ConsumptionFrom and ConsumptionTo as dimensions chances nothing.