topic Re: max monthyear in calculated dimension in QlikView https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460519#M793951 <HTML><HEAD></HEAD><BODY><P>try with </P><P>=max(total monthyear)</P></BODY></HTML> Mon, 08 Jan 2018 12:58:22 GMT Clever_Anjos 2018-01-08T12:58:22Z max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460511#M793943 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have written below expression in calculated dimension to get max month year but getting all months in dimension.</P><P></P><P>=aggr(max(monthyear),monthyear)</P><P></P><P>Please do the needful.</P><P></P><P>Regards,</P><P>Khalander</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460511#M793943 khalander 2020-11-25T16:16:04Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460512#M793944 <HTML><HEAD></HEAD><BODY><P>Try to use?</P><P></P><P><STRONG>=aggr(max(TOTAL monthyear),monthyear)</STRONG></P></BODY></HTML> Mon, 08 Jan 2018 12:40:25 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460512#M793944 Anil_Babu_Samineni 2018-01-08T12:40:25Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460513#M793945 <HTML><HEAD></HEAD><BODY><P>Hi Anil,</P><P></P><P>It is giving max month year but not get correct values for maximum month</P></BODY></HTML> Mon, 08 Jan 2018 12:43:28 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460513#M793945 khalander 2018-01-08T12:43:28Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460514#M793946 <HTML><HEAD></HEAD><BODY><P>Image please </P></BODY></HTML> Mon, 08 Jan 2018 12:48:52 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460514#M793946 Anil_Babu_Samineni 2018-01-08T12:48:52Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460515#M793947 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=aggr(max(monthyear),monthyear) will aggregated for every monthyear and calculating the max(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">monthyear</SPAN>), so that´s correct retrieving all monthyear</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">try with</SPAN></P><P>max(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">monthyear) </SPAN></P></BODY></HTML> Mon, 08 Jan 2018 12:49:15 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460515#M793947 Clever_Anjos 2018-01-08T12:49:15Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460516#M793948 <HTML><HEAD></HEAD><BODY><P>Hi Anjos,</P><P>It is showing error in calculated dimension message if i am giving max(monthyear)</P></BODY></HTML> Mon, 08 Jan 2018 12:52:34 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460516#M793948 khalander 2018-01-08T12:52:34Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460517#M793949 <HTML><HEAD></HEAD><BODY><P>Max() won't work in calculated instead why can't you write in expression and promote them to dimension place?</P></BODY></HTML> Mon, 08 Jan 2018 12:54:52 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460517#M793949 Anil_Babu_Samineni 2018-01-08T12:54:52Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460518#M793950 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">It should even work without aggr(), like <EM><STRONG>max( TOTAL monthyear)</STRONG></EM><STRONG> .</STRONG> If your monthyear is a dual field, this expression should work; you might want to format it like = <EM>monthname(max(<STRONG>total</STRONG> monthyear))</EM></SPAN></P></BODY></HTML> Mon, 08 Jan 2018 12:57:23 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460518#M793950 tresB 2018-01-08T12:57:23Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460519#M793951 <HTML><HEAD></HEAD><BODY><P>try with </P><P>=max(total monthyear)</P></BODY></HTML> Mon, 08 Jan 2018 12:58:22 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460519#M793951 Clever_Anjos 2018-01-08T12:58:22Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460520#M793952 <HTML><HEAD></HEAD><BODY><P>Yes It is giving max monthyear if i used total word&nbsp; but my expression values is coming total values instead of max month values</P></BODY></HTML> Mon, 08 Jan 2018 13:04:36 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460520#M793952 khalander 2018-01-08T13:04:36Z Re: max monthyear in calculated dimension https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460521#M793953 <HTML><HEAD></HEAD><BODY><P>include set analysis into your expression</P><P>Sum({&lt;<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">monthyear={"$(=Max(<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">monthyear</SPAN>))"}</SPAN>&gt;}Value)</P></BODY></HTML> Mon, 08 Jan 2018 13:26:24 GMT https://community.qlik.com/t5/QlikView/max-monthyear-in-calculated-dimension/m-p/1460521#M793953 Clever_Anjos 2018-01-08T13:26:24Z