topic Re: Expression Question (Data till last month) in App Development

Expression Question (Data till last month)

raju_salmon — Wed, 29 May 2019 03:23:01 GMT

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 — Wed, 29 May 2019 08:57:46 GMT

Hi Raju,

You can use this formula:

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

Jordy

Climber

raju_salmon — Wed, 29 May 2019 09:52:55 GMT

Million thanks Jordy.