topic Re: Accumulated - DSO in QlikView https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434725#M162048 <HTML><HEAD></HEAD><BODY><P>The idea would do in a PivotTable, in other words, create an expression.</P><P></P><P></P><P>You can?</P></BODY></HTML> Thu, 14 Feb 2013 11:55:06 GMT 2013-02-14T11:55:06Z Accumulated - DSO https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434722#M162045 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P></P><P>I balance my AR need to calculate how many days of net sales were needed to remedy my balance.</P><P></P><P></P><P>I have to do in QlikView exactly what I did in the worksheet below, ie Balance_AR - Net Sales, or even become negative zero.</P></BODY></HTML> Wed, 13 Feb 2013 21:54:15 GMT https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434722#M162045 2013-02-13T21:54:15Z Re: Accumulated - DSO https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434723#M162046 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Thu, 14 Feb 2013 07:55:09 GMT https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434723#M162046 Gysbert_Wassenaar 2013-02-14T07:55:09Z Re: Accumulated - DSO https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434724#M162047 <HTML><HEAD></HEAD><BODY><P>Perfect!</P><P></P><P></P><P>One question, you can do some similar object?</P><P>I would like to calculate the direct object, because I have a large volume of data to process.</P></BODY></HTML> Thu, 14 Feb 2013 11:37:39 GMT https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434724#M162047 2013-02-14T11:37:39Z Re: Accumulated - DSO https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434725#M162048 <HTML><HEAD></HEAD><BODY><P>The idea would do in a PivotTable, in other words, create an expression.</P><P></P><P></P><P>You can?</P></BODY></HTML> Thu, 14 Feb 2013 11:55:06 GMT https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434725#M162048 2013-02-14T11:55:06Z Re: Accumulated - DSO https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434726#M162049 <HTML><HEAD></HEAD><BODY><P>Ok, see attached example.</P></BODY></HTML> Thu, 14 Feb 2013 12:30:26 GMT https://community.qlik.com/t5/QlikView/Accumulated-DSO/m-p/434726#M162049 Gysbert_Wassenaar 2013-02-14T12:30:26Z