Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

hariprasad_koya
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

6 Replies
tripatirao
Contributor II

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.

hariprasad_koya
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

hariprasad_koya
New Contributor II

Re: Days Sales Outstanding(DSO) in Qlikview

HI Qlik Experts,

Can anyone please help me out regarding the above query.

Regards,

Hari

arunaerra
Contributor

Re: Days Sales Outstanding(DSO) in Qlikview

Hi

please find the attached app

hariprasad_koya
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

arunaerra
Contributor

Re: Days Sales Outstanding(DSO) in Qlikview

Hi  Hari Prasad,

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:

LOAD Customer,

 

      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

[..\..\Downloads\Sampledata.xlsx]

(ooxml, embedded labels, table is Sheet1);

LOAD *,

([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.

Capture2.PNG

Community Browser