# Qlik Sense App Development

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for
Did you mean:
Highlighted
Contributor III

## Qliksense : Rangesum (cumulative sum) to use in existing expression

Hi There,

Thanks for looking into this.

Count(TICKET_ID) / COUNT ( TOTAL <CLOSED_MONTH_CALC> TICKET_ID)

above formula calculates the % per CLOSED_MONTH_CALC

we need to introduce running sum as mentioned below per CLOSED_MONTH_CALC -

Thanks for looking into this..

Best Regards,

Rahul

1 Solution

Accepted Solutions
Highlighted
MVP

Try this

RangeSum(Before(Count(TICKET_ID) / COUNT ( TOTAL <CLOSED_MONTH_CALC> TICKET_ID), 0, ColumnNo()))

6 Replies
Highlighted
MVP

Try this

RangeSum(Before(Count(TICKET_ID) / COUNT ( TOTAL <CLOSED_MONTH_CALC> TICKET_ID), 0, ColumnNo()))

Highlighted
Contributor III

Thank you Sunny.. 🙂

Highlighted
Contributor III

Hi Sunny,

Thanks for the help. 🙂 & sorry for the continuous queries on this subject.

The above solution is working fine however there is another requirement.. I have added another row named as 'CLOSED_DATE' beneath CLOSED_MONTH_CALC which has dates in it(falling under month of CLOSED_MONTH_CALC ).

i want to calculate the runningsum for 'CLOSED_DATE' as well. Please recommend how it can be achieved :)-

* do i need to add something to below formula - ?

RangeSum(Before(Count(TICKET_ID) / COUNT ( TOTAL TICKET_ID), 0, ColumnNo()))

* Or need to add another measure?

Thanks again

Best Regards,

Rahul

Highlighted
MVP

I am not sure I follow the req completely... do you mind sharing an example to show what is going on?

Highlighted
Contributor III

No worries. it worked out.. thanks for replying.

Have a good day.

Highlighted
MVP

Awesome!!