topic Calculated Dimension Problem in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-Problem/m-p/379916#M494700 <HTML><HEAD></HEAD><BODY><P>Help guys,</P><P>I have a calculated dimension to calculate the number of days between when the document was created and when the work was completed.&nbsp; However for some reason it does not like my expression.</P><P>Thanks</P><P>Thom</P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 12pt;">=<SPAN style="color: #0000ff;">interval</SPAN>({&lt;Final_Status = {C}&gt;} WEDAT - <SPAN style="color: #800000;">[Document Date]</SPAN>,'d') </SPAN></P><P></P></BODY></HTML> Wed, 22 Aug 2012 12:13:18 GMT tmumaw 2012-08-22T12:13:18Z Calculated Dimension Problem https://community.qlik.com/t5/QlikView/Calculated-Dimension-Problem/m-p/379916#M494700 <HTML><HEAD></HEAD><BODY><P>Help guys,</P><P>I have a calculated dimension to calculate the number of days between when the document was created and when the work was completed.&nbsp; However for some reason it does not like my expression.</P><P>Thanks</P><P>Thom</P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 12pt;">=<SPAN style="color: #0000ff;">interval</SPAN>({&lt;Final_Status = {C}&gt;} WEDAT - <SPAN style="color: #800000;">[Document Date]</SPAN>,'d') </SPAN></P><P></P></BODY></HTML> Wed, 22 Aug 2012 12:13:18 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-Problem/m-p/379916#M494700 tmumaw 2012-08-22T12:13:18Z Re: Calculated Dimension Problem https://community.qlik.com/t5/QlikView/Calculated-Dimension-Problem/m-p/379917#M494701 <HTML><HEAD></HEAD><BODY><P>Are both parts of the formula in date format?</P><P>If C is a text value you might need speech marks ={"C"}</P></BODY></HTML> Wed, 22 Aug 2012 12:31:51 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-Problem/m-p/379917#M494701 2012-08-22T12:31:51Z