Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danmercer
Creator
Creator

Compounding Table

Hi All,

This might be one of those things that is possible in excel, but not QlikView. We have a report that we manually do in excel that essentially calculates Churn (a loss of revenues).  However, we do this compounding.  So if we lose the revenues in January, we also will show that those revenues are lost in February, March, etc. 

Can this be done in a table or pivot table?  Can I turn this:

Capture.JPG

Into this:

Capture.JPG

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe an accumulation approach should fit your need then?

Maybe just something like

= Rangesum( Before( Sum(ChurnField),0, ColumnNo() ))

View solution in original post

3 Replies
swuehl
MVP
MVP

Maybe an accumulation approach should fit your need then?

Maybe just something like

= Rangesum( Before( Sum(ChurnField),0, ColumnNo() ))

danmercer
Creator
Creator
Author

Thats awesome! Thanks!  Can this be done with set analysis?  Below is the formula that I was using.

SUM({$<Won_Flag={1}, ChurnYear = {'2016'}>}[Churn MRR])

I'd also like to know if there is a way to guarantee the months as headers.  While highly unlikely, there's no guarantee that we'll have churn in any particular month. Though I think that might be for another thread.

swuehl
MVP
MVP

It should work with just replacing my sum(ChurnField) with your expression (sum with set analysis).

I would suggest opening another thread for your second question (or search the forum, there are some threads available that are coping with this kind of issue).