Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hariprasad_koya
Contributor III
Contributor III

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
Creator II
Creator II

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

HI Qlik Experts,

Can anyone please help me out regarding the above query.

Regards,

Hari

Anonymous
Not applicable

Hi

please find the attached app

hariprasad_koya
Contributor III
Contributor III
Author

Hi Aruna,

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

Regards,

Hari

Anonymous
Not applicable

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