Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
Highlighted
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
Highlighted
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.