topic Re: How can I fix below problem? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563752#M210378 <HTML><HEAD></HEAD><BODY><P>Change your expression to:</P><P>FirstSortedValue(fabs(RRE_BSAllData.RRE_FocusAmount),-Date)</P></BODY></HTML> Fri, 14 Mar 2014 18:19:43 GMT Nicole-Smith 2014-03-14T18:19:43Z How can I fix below problem? https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563749#M210375 <HTML><HEAD></HEAD><BODY><P><IMG alt="1.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/54781_1.jpg" style="width: 620px; height: 55px;" /></P><P>Dear Experts,</P><P></P><P>example - </P><P>in Year 2009, I have 4 quarter - Q1,Q2,Q3 and Q4.</P><P></P><P>When I collapse 2009 then I want to show all the time last quarter value, Q4 - 92.43.</P><P>In expression I used Max(amount) it returns the max Quarter value when I collapse.it shows - Q2 - 207.74.</P><P></P><P>Please give me solution.</P><P></P><P>Thanks</P><P>saifur</P></BODY></HTML> Wed, 12 Mar 2014 11:52:34 GMT https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563749#M210375 2014-03-12T11:52:34Z Re: How can I fix below problem? https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563750#M210376 <HTML><HEAD></HEAD><BODY><P>can you share your sample file or apps?</P></BODY></HTML> Wed, 12 Mar 2014 11:54:06 GMT https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563750#M210376 MK_QSL 2014-03-12T11:54:06Z Re: Re: How can I fix below problem? https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563751#M210377 <HTML><HEAD></HEAD><BODY><P>Please see the attached file.</P><P></P><P>I need to show last quarter value when collapse.</P></BODY></HTML> Thu, 13 Mar 2014 11:32:06 GMT https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563751#M210377 2014-03-13T11:32:06Z Re: How can I fix below problem? https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563752#M210378 <HTML><HEAD></HEAD><BODY><P>Change your expression to:</P><P>FirstSortedValue(fabs(RRE_BSAllData.RRE_FocusAmount),-Date)</P></BODY></HTML> Fri, 14 Mar 2014 18:19:43 GMT https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563752#M210378 Nicole-Smith 2014-03-14T18:19:43Z Re: How can I fix below problem? https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563753#M210379 <HTML><HEAD></HEAD><BODY><P>Hi Nicole,</P><P></P><P>Thanks for giving me the solution.It works.</P><P></P><P>Thanks</P><P>saifur</P></BODY></HTML> Sat, 15 Mar 2014 04:48:18 GMT https://community.qlik.com/t5/QlikView/How-can-I-fix-below-problem/m-p/563753#M210379 2014-03-15T04:48:18Z