Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
raju_salmon
Contributor II

Expression Question (Data till last month)

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Expression Question (Data till last month)

Hi Raju,

You can use this formula:

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

Jordy

Climber 

Work smarter, not harder

View solution in original post

2 Replies
Partner
Partner

Re: Expression Question (Data till last month)

Hi Raju,

You can use this formula:

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

Jordy

Climber 

Work smarter, not harder

View solution in original post

raju_salmon
Contributor II

Re: Expression Question (Data till last month)

Million thanks Jordy.