topic Re: Dimension Help in QlikView https://community.qlik.com/t5/QlikView/Dimension-Help/m-p/1041656#M464218 <HTML><HEAD></HEAD><BODY><P>Try using Max instead of MaxString. MaxString works on text values. Subtracting 12 from a text string won't give a result.</P></BODY></HTML> Thu, 28 Apr 2016 17:56:10 GMT Gysbert_Wassenaar 2016-04-28T17:56:10Z Dimension Help https://community.qlik.com/t5/QlikView/Dimension-Help/m-p/1041655#M464217 <HTML><HEAD></HEAD><BODY><P>I want to group some dates in a dimension using the below expression:</P><P></P><P>if([New/Existing]&gt;MaxString({&lt;Date=,Month=,Year=,MonthYear=,PeriodNum={"$(=Max(PeriodNum))"}&gt;}[MonthYear])-12,'Yes','No')</P><P></P><P>the dates I am using are :</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/123020_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>I want to attach values to the yes or no grouping based on the formula above, so when I change date the formula is dynamically changing.</P><P></P><P>The expression above returns an invalid dimension, can anyone help me</P></BODY></HTML> Thu, 28 Apr 2016 17:14:36 GMT https://community.qlik.com/t5/QlikView/Dimension-Help/m-p/1041655#M464217 2016-04-28T17:14:36Z Re: Dimension Help https://community.qlik.com/t5/QlikView/Dimension-Help/m-p/1041656#M464218 <HTML><HEAD></HEAD><BODY><P>Try using Max instead of MaxString. MaxString works on text values. Subtracting 12 from a text string won't give a result.</P></BODY></HTML> Thu, 28 Apr 2016 17:56:10 GMT https://community.qlik.com/t5/QlikView/Dimension-Help/m-p/1041656#M464218 Gysbert_Wassenaar 2016-04-28T17:56:10Z