Qlik Community

Qlik Sense App Development

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

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

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

Hi There,

Thanks for looking into this.

Request you to please help me in refining the existing expression by adding the rangesum in it as mentioned in following screenshot-

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 -

Untitled.png

Thanks for looking into this..

Best Regards,

Rahul

1 Solution

Accepted Solutions
Highlighted

Try this

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

View solution in original post

6 Replies
Highlighted

Try this

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

View solution in original post

Highlighted
Contributor III
Contributor III

Thank you Sunny.. 🙂

Highlighted
Contributor III
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

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

Highlighted
Contributor III
Contributor III

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

Have a good day.

Highlighted

Awesome!!