6 Replies Latest reply: Apr 17, 2018 1:28 AM by Aruna dabba

# 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

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

Please share your out put by selecting one year or month.

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

Regards.

• ###### 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

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

HI Qlik Experts,

Can anyone please help me out regarding the above query.

Regards,

Hari

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

Hi

please find the attached app

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

Hi Aruna,

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

Regards,

Hari

• ###### 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);

([AR Outstanding]/Sales)*Days as DSO

Resident T1;

DROP Table T1;

in  the chart take Month as dimension and in the expression =sum(DSO)

I hope it will help u.