Expression Question (Data till last month)

[raju_salmon]

Hi Experts,

I am trying to create a chart however stuck with one of the KPIs expression. Could you please help me on this?

Attached the sample data and chart represent that i want to create in Qlik Sense.

Regards,

Raju

[JordyWegman · Accepted solution]

Hi Raju,

You can use this formula:

 Aggr(RangeSum(Above(Sum(Complains), 0, RowNo())), Month)

Jordy

Climber 

[raju_salmon]

Million thanks Jordy.