topic Re: How to select the previous value? in QlikView https://community.qlik.com/t5/QlikView/How-to-select-the-previous-value/m-p/604103#M681606 <HTML><HEAD></HEAD><BODY><P>Try maybe something like</P><P></P><P>=avg( aggr( (max(Date)-min(Date)) / (count(Date)-1), [Sales man], Client))</P></BODY></HTML> Fri, 04 Apr 2014 17:07:44 GMT swuehl 2014-04-04T17:07:44Z How to select the previous value? https://community.qlik.com/t5/QlikView/How-to-select-the-previous-value/m-p/604101#M681604 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I want to see how many days between my clients sales.</P><P>I tried to use =avg(aggr(Date-Above(Total Date),Client,Date)) but it doesn't work well.</P><P></P><P></P><P>I want to achieve somenthing like this:</P><P><IMG alt="Sem título.png" class="jive-image" src="/legacyfs/online/56634_Sem título.png" /></P><P></P><P></P><P>Can some one help-me?</P></BODY></HTML> Fri, 04 Apr 2014 16:59:19 GMT https://community.qlik.com/t5/QlikView/How-to-select-the-previous-value/m-p/604101#M681604 mendoncart 2014-04-04T16:59:19Z Re: How to select the previous value? https://community.qlik.com/t5/QlikView/How-to-select-the-previous-value/m-p/604102#M681605 <HTML><HEAD></HEAD><BODY><P>Maybe this will point you in the right direction, from the QV help manual...</P><P></P><P class="syntax"><A name="kanchor46"></A><A name="previous"></A><SPAN class="Bold">previous(</SPAN><SPAN class="Italic">expression </SPAN><SPAN class="Bold">)</SPAN> </P><P>Returns the value of <SPAN class="Italic">expression</SPAN> using data from the previous input record that was not discarded due to a <SPAN class="Bold">where</SPAN> clause. In the first record of an internal table the function will return NULL. The previous function may be nested in order to access records further back. Data are fetched directly from the input source, making it possible to refer also to fields which have not been loaded into QlikView, i.e. even if they have not been stored in its associative database. </P></BODY></HTML> Fri, 04 Apr 2014 17:03:25 GMT https://community.qlik.com/t5/QlikView/How-to-select-the-previous-value/m-p/604102#M681605 2014-04-04T17:03:25Z Re: How to select the previous value? https://community.qlik.com/t5/QlikView/How-to-select-the-previous-value/m-p/604103#M681606 <HTML><HEAD></HEAD><BODY><P>Try maybe something like</P><P></P><P>=avg( aggr( (max(Date)-min(Date)) / (count(Date)-1), [Sales man], Client))</P></BODY></HTML> Fri, 04 Apr 2014 17:07:44 GMT https://community.qlik.com/t5/QlikView/How-to-select-the-previous-value/m-p/604103#M681606 swuehl 2014-04-04T17:07:44Z