https://community.qlik.com/t5/QlikView/Calculated-Dimension-not-working-Error-in-Calculated-dimension/m-p/1726893#M452074 <P>Good day,</P><P>&nbsp;</P><P>I am struggling with creating a calculated dimension.</P><P>I have an expression which works when done on textbox however when made a calculated dimension it does not work.</P><P>Please see below:</P><P>expression:</P><P>=if(Date(Date#((Effective_Month_Key), 'YYYYMM'), 'YYYYMM') - Date(Date#(Date(max(Last_Hire_Dte)), 'YYYY/MM/DD'), 'YYYYMM') &gt;=90 and Staff_Type_Descr ='Temporary','Permanent',Staff_Type_Descr)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="skzwane01_0-1594395050634.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37299i8820A02A41557FA6/image-size/medium?v=v2&amp;px=400" role="button" title="skzwane01_0-1594395050634.png" alt="skzwane01_0-1594395050634.png" /></span></P><P>This works fine on the textbox.</P><P>&nbsp;</P><P>When done as a calculated dimension it does not work. Please see below&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="skzwane01_1-1594395209710.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37300i69613896B3A17444/image-size/medium?v=v2&amp;px=400" role="button" title="skzwane01_1-1594395209710.png" alt="skzwane01_1-1594395209710.png" /></span></P><P>Please assist. How can I resolve ?</P><P>&nbsp;</P><P>Kind Regards,</P> Sat, 16 Nov 2024 18:23:16 GMT skzwane01 2024-11-16T18:23:16Z https://community.qlik.com/t5/QlikView/Calculated-Dimension-not-working-Error-in-Calculated-dimension/m-p/1726893#M452074 <P>Good day,</P><P>&nbsp;</P><P>I am struggling with creating a calculated dimension.</P><P>I have an expression which works when done on textbox however when made a calculated dimension it does not work.</P><P>Please see below:</P><P>expression:</P><P>=if(Date(Date#((Effective_Month_Key), 'YYYYMM'), 'YYYYMM') - Date(Date#(Date(max(Last_Hire_Dte)), 'YYYY/MM/DD'), 'YYYYMM') &gt;=90 and Staff_Type_Descr ='Temporary','Permanent',Staff_Type_Descr)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="skzwane01_0-1594395050634.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37299i8820A02A41557FA6/image-size/medium?v=v2&amp;px=400" role="button" title="skzwane01_0-1594395050634.png" alt="skzwane01_0-1594395050634.png" /></span></P><P>This works fine on the textbox.</P><P>&nbsp;</P><P>When done as a calculated dimension it does not work. Please see below&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="skzwane01_1-1594395209710.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37300i69613896B3A17444/image-size/medium?v=v2&amp;px=400" role="button" title="skzwane01_1-1594395209710.png" alt="skzwane01_1-1594395209710.png" /></span></P><P>Please assist. How can I resolve ?</P><P>&nbsp;</P><P>Kind Regards,</P> Sat, 16 Nov 2024 18:23:16 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-not-working-Error-in-Calculated-dimension/m-p/1726893#M452074 skzwane01 2024-11-16T18:23:16Z https://community.qlik.com/t5/QlikView/Calculated-Dimension-not-working-Error-in-Calculated-dimension/m-p/1726897#M452075 <P>you need aggr function to work your calculated dimension correctly</P><P><SPAN>=<STRONG>aggr(</STRONG>if(Date(Date#((Effective_Month_Key), 'YYYYMM'), 'YYYYMM') - Date(Date#(Date(max(Last_Hire_Dte)), 'YYYY/MM/DD'), 'YYYYMM') &gt;=90 and Staff_Type_Descr ='Temporary','Permanent',Staff_Type_Descr),<STRONG> Staff_Type_Descr</STRONG>)</SPAN></P> Fri, 10 Jul 2020 15:38:42 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-not-working-Error-in-Calculated-dimension/m-p/1726897#M452075 Kushal_Chawda 2020-07-10T15:38:42Z