topic DSO Report Query in QlikView

DSO Report Query

neetu_singh — Thu, 12 Aug 2010 12:43:07 GMT

Hi Everyone,

I need a help and its urgent. Actually, I have to design a DSO report and the calculation for this DSO is as below:

Today_Date - Invoice_Date + Limit_Days < 0, then its outstanding

this is working perfectly fine. but on current date, if i select previous month, it will not shows any outstanding.

So, i required on selection "Outstanding". Like ,now its august. so if i select "August" it will give me outstanding bt if i select "june" it will not give outstanding which i required.

If anyone have solution please reply ASAP.

Thanks in advance

DSO Report Query

Thu, 12 Aug 2010 12:47:42 GMT

Hi,

If i understood your question, below code may help you.

Max(Selected Date) - Invoice_Date + Limit_Days < 0

-Sridhar

DSO Report Query

orlando — Thu, 12 Aug 2010 22:14:17 GMT

Hello

perhaps this helps:

=if(num(Invoice_Date)+Limit_Days<num(today()),'outstanding since ' & date(num(Invoice_Date)+Limit_Days) ,'not outstanding')

Regards

Orlando