topic Re: Calculated Dimension moved to expression in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-moved-to-expression/m-p/363130#M573976 <HTML><HEAD></HEAD><BODY><P>Bump!</P></BODY></HTML> Thu, 21 Jun 2012 21:46:13 GMT 2012-06-21T21:46:13Z Calculated Dimension moved to expression https://community.qlik.com/t5/QlikView/Calculated-Dimension-moved-to-expression/m-p/363129#M573975 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>I have a graph with two calculated dimensions and an expression. How would I change the calculated dimensions to plain dimensions of GL_Account_Number_Name_Balance_Sheet3 and Department_Number_Name3?</P><P></P><P>Here are the calculated dimensions:</P><P>=if(match(QB22,el2),GL_Account_Number_Name_Balance_Sheet3) </P><P>=if(match(QB33,el3),Department_Number_Name3) </P><P></P><P>Here is the expression:</P><P>sum({ $&lt; QBbalcode={'DLHOURS'},</P><P>LinkYear={$(=Only("CurrentDocumentYear"))},</P><P>LinkMonth=CurrentDocumentMonth3,</P><P><PRE>={'RBIACCT'}</PRE></P><P>&gt;}full_value) </P><P></P><P>I've tried a lot of different things but can't get the same totals. Any ideas? The reason I want to move away from calculated dimensions is that when you click on one it selects all the fields included in the calculation.</P></BODY></HTML> Thu, 21 Jun 2012 18:21:20 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-moved-to-expression/m-p/363129#M573975 2012-06-21T18:21:20Z Re: Calculated Dimension moved to expression https://community.qlik.com/t5/QlikView/Calculated-Dimension-moved-to-expression/m-p/363130#M573976 <HTML><HEAD></HEAD><BODY><P>Bump!</P></BODY></HTML> Thu, 21 Jun 2012 21:46:13 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-moved-to-expression/m-p/363130#M573976 2012-06-21T21:46:13Z