topic Calculated Dimension for Greater than in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460537#M171931 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to get a calculated dimension for DOH_Start greater than vOneYearBack.</P><P></P><P>DOH_Start is mm/dd/yyy and vOneYearBack is 12/31/2012. </P><P></P><P>Any ideas please.</P><P></P><P>Thank you,</P><P>Oneputtgirl</P></BODY></HTML> Tue, 02 Oct 2012 20:33:02 GMT 2012-10-02T20:33:02Z Calculated Dimension for Greater than https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460537#M171931 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to get a calculated dimension for DOH_Start greater than vOneYearBack.</P><P></P><P>DOH_Start is mm/dd/yyy and vOneYearBack is 12/31/2012. </P><P></P><P>Any ideas please.</P><P></P><P>Thank you,</P><P>Oneputtgirl</P></BODY></HTML> Tue, 02 Oct 2012 20:33:02 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460537#M171931 2012-10-02T20:33:02Z Re: Calculated Dimension for Greater than https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460538#M171932 <HTML><HEAD></HEAD><BODY><P>Try something like the following expression:</P><P></P><P><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">sum</SPAN>({$&lt;<SPAN style="color: #800000;">DOH_Start</SPAN>={<SPAN style="color: #800000;">"&lt;=$(vOneYearBack)"</SPAN>}&gt;} <SPAN style="color: #800000;">YourField</SPAN>) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Make sure that your date formats match exactly.</SPAN></P></BODY></HTML> Tue, 02 Oct 2012 21:59:49 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460538#M171932 2012-10-02T21:59:49Z Re: Calculated Dimension for Greater than https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460539#M171933 <HTML><HEAD></HEAD><BODY><P>Hi Oneputtgirl,</P><P></P><P>try this to create a calc dim with DOH_Start:</P><P></P><P>=if(DOH_Start &gt;= '$(vOneYearBack)', DOH_Start)</P><P></P><P></P><P>May be you have to check "Suppress when Value is Null" for this dimension.</P><P></P><P>HtH</P><P>Roland</P></BODY></HTML> Wed, 03 Oct 2012 12:42:22 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460539#M171933 2012-10-03T12:42:22Z Re: Calculated Dimension for Greater than https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460540#M171934 <HTML><HEAD></HEAD><BODY><P><BR />Thank you for your support everyone. Sivaraj and Rebeccad this would work for an expression, but not for a dimension calculation. </P></BODY></HTML> Wed, 03 Oct 2012 14:56:41 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-for-Greater-than/m-p/460540#M171934 2012-10-03T14:56:41Z