topic Re: Qliksense : Rangesum (cumulative sum) to use in existing expression in App Development

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

rahulgoyal1287 — Wed, 22 Dec 2021 20:40:09 GMT

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 -

Thanks for looking into this..

Best Regards,

Rahul

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

sunny_talwar — Thu, 19 Jul 2018 11:51:00 GMT

Try this

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

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

rahulgoyal1287 — Tue, 24 Jul 2018 10:29:14 GMT

Thank you Sunny.. 🙂

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

rahulgoyal1287 — Mon, 30 Jul 2018 09:41:10 GMT

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

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

sunny_talwar — Mon, 30 Jul 2018 11:09:54 GMT

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

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

rahulgoyal1287 — Mon, 30 Jul 2018 11:19:38 GMT

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

Have a good day.

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

sunny_talwar — Mon, 30 Jul 2018 11:20:17 GMT

Awesome!!