Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator 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
JordyWegman
Partner - Master
Partner - Master

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
JordyWegman
Partner - Master
Partner - Master

Hi Raju,

You can use this formula:

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

Jordy

Climber 

Work smarter, not harder
raju_salmon
Creator II
Creator II
Author

Million thanks Jordy.