Days Sales Outstanding(DSO) in Qlikview

[hariprasad_koya]

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

[tripatirao]

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]

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]

HI Qlik Experts,

Can anyone please help me out regarding the above query.

Regards,

Hari

[Anonymous]

Hi

please find the attached app

[hariprasad_koya]

Hi Aruna,

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

Regards,

Hari

[Anonymous]

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.