topic Re: Max value from a rolling quarter in QlikView https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437166#M809629 <HTML><HEAD></HEAD><BODY><P>If you use Max() then ??</P></BODY></HTML> Wed, 11 Oct 2017 17:01:41 GMT Anil_Babu_Samineni 2017-10-11T17:01:41Z Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437164#M809627 <HTML><HEAD></HEAD><BODY><P>Below is few examples of a field that has rolling quarter. These values are derived from a date column (YYYYMM format).</P><P></P><P>How to achieve the result as seen below in a chart? It's always 4 rolling quarters. Minstring and Maxstring doesn't always give correct result.</P><P></P><P>1)</P><P>2Q 2016<BR />3Q 2016<BR />4Q 2016<BR />1Q 2017<BR />Result = 1Q 2017</P><P></P><P>2)</P><P>3Q 2016<BR />4Q 2016<BR />1Q 2017<BR />2Q 2017<BR />Result = 2Q 2017</P><P></P><P>3)</P><P>4Q 2016<BR />1Q 2017<BR />2Q 2017<BR />3Q 2017<BR />Result = 3Q 2017</P><P></P><P>4)</P><P>4Q 2017<BR />3Q 2017<BR />2Q 2017<BR />1Q 2018<BR />Result = 1Q 2018</P><P></P><P>Minstring(QtrYr)<BR />Maxstring(QtrYr)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437164#M809627 newqlik2017 2020-11-25T16:16:04Z Re: Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437165#M809628 <HTML><HEAD></HEAD><BODY><P>You can try FirstSortedValue. You need to be more specific on what the requirement is. </P></BODY></HTML> Wed, 11 Oct 2017 16:50:49 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437165#M809628 vkish16161 2017-10-11T16:50:49Z Re: Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437166#M809629 <HTML><HEAD></HEAD><BODY><P>If you use Max() then ??</P></BODY></HTML> Wed, 11 Oct 2017 17:01:41 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437166#M809629 Anil_Babu_Samineni 2017-10-11T17:01:41Z Re: Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437167#M809630 <HTML><HEAD></HEAD><BODY><P>MIN n MAX functions work for numeric data type. In this example, the values are string (non numeric) type. So MAX() doesn't work.</P></BODY></HTML> Wed, 11 Oct 2017 17:07:47 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437167#M809630 newqlik2017 2017-10-11T17:07:47Z Re: Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437168#M809631 <HTML><HEAD></HEAD><BODY><P>May be assign this field an underlying numeric value...</P><P></P><P><STRONG>LOAD Dual(Pick(WildMatch(QuarterYear, '1Q*', '2Q*', '3Q*', '4Q*'), 3, 6, 9, 12) + Right(</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>QuarterYear, 4), </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>QuarterYear) as </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>QuarterYear</STRONG></SPAN></SPAN></SPAN></P><P></P><P>and now max and maxstring will both work</P></BODY></HTML> Wed, 11 Oct 2017 17:14:16 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437168#M809631 sunny_talwar 2017-10-11T17:14:16Z Re: Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437169#M809632 <HTML><HEAD></HEAD><BODY><P>HI Subash,</P><P>Try</P><P></P><P>=Div(Month(max(Date))-1,3)+1 &amp; 'Q ' &amp; Year(max(Date))</P><P></P><P>Regards</P><P></P><P>Andrew</P></BODY></HTML> Thu, 12 Oct 2017 08:22:12 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437169#M809632 effinty2112 2017-10-12T08:22:12Z Re: Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437170#M809633 <HTML><HEAD></HEAD><BODY><P>Hi Andrew and Sunny,</P><P>Thank you for your response. I tried both the option but didn't seem to work.</P><P></P><P>I attached a sample QVW. Basically, I need to get the latest value of the rolling quarter - either in YYYYMM format or &lt;Qtr_Num&gt;Q YYYY (for instance 1Q 2017).</P><P></P><P>Any ideas, please?</P></BODY></HTML> Fri, 13 Oct 2017 12:02:25 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437170#M809633 newqlik2017 2017-10-13T12:02:25Z Re: Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437171#M809634 <HTML><HEAD></HEAD><BODY><P>Check the attached now</P></BODY></HTML> Fri, 13 Oct 2017 12:12:11 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437171#M809634 sunny_talwar 2017-10-13T12:12:11Z Re: Max value from a rolling quarter https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437172#M809635 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny.</P></BODY></HTML> Fri, 13 Oct 2017 12:45:13 GMT https://community.qlik.com/t5/QlikView/Max-value-from-a-rolling-quarter/m-p/1437172#M809635 newqlik2017 2017-10-13T12:45:13Z