topic Displaying value for the last occurence in QlikView https://community.qlik.com/t5/QlikView/Displaying-value-for-the-last-occurence/m-p/422846#M1159220 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I am trying to return values only for the last date occurence. For example, if a rep made a call to a customer last year it will return scenario 1 , however, if we made another contact to the same customer this year, it will return scenario 2. I want to return a scenario only for the max date. </P><P></P><P>Date, Policy #, Scenario</P><P>12/10/2011, ABC123,1</P><P>12/11/2012,ABC123,2</P><P></P><P>Please help. Let me know if you have any questions. </P><P></P><P>Thank you,</P></BODY></HTML> Mon, 10 Dec 2012 21:34:09 GMT 2012-12-10T21:34:09Z Displaying value for the last occurence https://community.qlik.com/t5/QlikView/Displaying-value-for-the-last-occurence/m-p/422846#M1159220 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I am trying to return values only for the last date occurence. For example, if a rep made a call to a customer last year it will return scenario 1 , however, if we made another contact to the same customer this year, it will return scenario 2. I want to return a scenario only for the max date. </P><P></P><P>Date, Policy #, Scenario</P><P>12/10/2011, ABC123,1</P><P>12/11/2012,ABC123,2</P><P></P><P>Please help. Let me know if you have any questions. </P><P></P><P>Thank you,</P></BODY></HTML> Mon, 10 Dec 2012 21:34:09 GMT https://community.qlik.com/t5/QlikView/Displaying-value-for-the-last-occurence/m-p/422846#M1159220 2012-12-10T21:34:09Z Re: Displaying value for the last occurence https://community.qlik.com/t5/QlikView/Displaying-value-for-the-last-occurence/m-p/422847#M1159221 <HTML><HEAD></HEAD><BODY><P>Check with FirstSortedValue function</P><P>FirstSortedValue(Scenario, -Num(Date))</P></BODY></HTML> Mon, 10 Dec 2012 22:05:43 GMT https://community.qlik.com/t5/QlikView/Displaying-value-for-the-last-occurence/m-p/422847#M1159221 CELAMBARASAN 2012-12-10T22:05:43Z Re: Displaying value for the last occurence https://community.qlik.com/t5/QlikView/Displaying-value-for-the-last-occurence/m-p/422848#M1159222 <HTML><HEAD></HEAD><BODY><P>You can use min(Date-today)</P></BODY></HTML> Tue, 11 Dec 2012 05:07:36 GMT https://community.qlik.com/t5/QlikView/Displaying-value-for-the-last-occurence/m-p/422848#M1159222 sujeetsingh 2012-12-11T05:07:36Z