Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor II
Partner - Contributor II

Debtor Days or Days Sales Outstanding (DSO) - Countback method

I work for a legal services organisation which uses the countback method of calculating debtor days, taking a month end debt value and subtracting sales month by month until reaching zero. The result is a value in number of days. A fairly succinct description of the methodology can be found here (3rd method listed):

The countback method is something we're finding difficult to implement in a dynamic QlikView data model without creating separate data tables for all the pre-defined ways the company wishes to see the data - in which case we might as well continue to produce the metric in Excel because it reduces the discovery value of a QlikView app.

In effect, we're trying to conduct a kind of "goal-seek" exercise whereby we want to know how many days' sales backwards we need to count to pay off all our debt. We have both sales and debt fact tables at an invoice level. Does anyone have any experience of implementing something similar using set analysis or other method? I would really appreciate any assistance available.

Many thanks.

1 Reply

If you wanted to do it purely within a chart expression then you would have to do something like the attached.

I have tried to break up each part of the expression into individual expressions to make it a bit more readable.

I have also used similar data to that in the same calculation in the link you provided.