# New to QlikView

Discussion board where members can get started with QlikView.

New Contributor II

## Days Sales Outstanding(DSO) in Qlikview

Hi Friends,

I just require help regarding DSO(Days Sales Outstanding) Calculation. Below is the Calculation formula :

DSO = (AROutstanding/Sales)*Number of Days

Iam attaching a Sample QVW and a sample excel for this.Iam giving below normal calculations we use in DSO for your understanding.

DSO for that Month= (AROutstanding Total for that month/Sales for that Month)*Number of days in that month

DSO for that week= (AROutstanding Total for that Week/Sales for that Week)*Number of days in that week

DSO for that selected days=(AROutstanding Total for that Selected days/Sales for that selected days)*Number of selected days

DSO for that Year= (AROutstanding Total for that Year/Sales for that Year)*Number of days in that Year

Kindly require help regarding this.

Regards,

Hari

Tags (1)
6 Replies
Contributor II

## Re: Days Sales Outstanding(DSO) in Qlikview

If you select Jan month then what should be the expected out put.

Regards.

New Contributor II

## Re: Days Sales Outstanding(DSO) in Qlikview

Hi Tripati,

If you select Jan Month,

DSO for Jan Month= (AROutstanding Total for Jan month/Sales for Jan Month)*Number of days in Jan month

Thanks,

Hari

New Contributor II

HI Qlik Experts,

Regards,

Hari

Contributor

## Re: Days Sales Outstanding(DSO) in Qlikview

Hi

New Contributor II

## Re: Days Sales Outstanding(DSO) in Qlikview

Hi Aruna,

Iam not able to find any attached file....Can u pls check once.

Regards,

Hari

Contributor

## Re: Days Sales Outstanding(DSO) in Qlikview

May be you are using desktop version , It is able to display in licenced  version.

I calculated DSO in the back end it used in the charts as required.

Directory;

T1:

Date#(Date(Date,'MM/DD/YYYY'),'MM/DD/YYYY') as Date,

SubField(Date#(Date(Date,'MM/DD/YYYY'),'MM/DD/YYYY'),'/',1) as Month,

SubField(Date#(Date(Date,'MM/DD/YYYY'),'MM/DD/YYYY'),'/',3) as Year,

SubField(Date#(Date(Date,'MM/DD/YYYY'),'MM/DD/YYYY'),'/',3)& SubField(Date#(Date(Date,'MM/DD/YYYY'),'MM/DD/YYYY'),'/',1) as YearMonth,

Day(MonthEnd(Date#(Date(Date,'MM/DD/YYYY'),'MM/DD/YYYY'))) as Days,

[AR Outstanding],

Sales

FROM

(ooxml, embedded labels, table is Sheet1);