topic Conditional expression based on dimension value in QlikView https://community.qlik.com/t5/QlikView/Conditional-expression-based-on-dimension-value/m-p/471238#M488730 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to only have a calculation execute when the dimension is above a given value?&nbsp; As an example; </P><P>Years =&nbsp; 2010, 2011 and 2012 </P><P>Actual Sales for 2010</P><P>Budget Forecast and Actuals for 2011</P><P>Budget and Forecast for 2012</P><P></P><P>I want to compare 2011 Budget versus Forecast so there wouldn't be a variance calculation for 2010 - so I want to show only Actuals; however for 2011 and 2012 I want to calculate the variance between actual sales and the 2011 Budget.&nbsp; Is it possible - if my scenario makes sense!?</P><P></P><P>Thanks</P><P>C</P></BODY></HTML> Tue, 27 Nov 2012 15:28:10 GMT 2012-11-27T15:28:10Z Conditional expression based on dimension value https://community.qlik.com/t5/QlikView/Conditional-expression-based-on-dimension-value/m-p/471238#M488730 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is it possible to only have a calculation execute when the dimension is above a given value?&nbsp; As an example; </P><P>Years =&nbsp; 2010, 2011 and 2012 </P><P>Actual Sales for 2010</P><P>Budget Forecast and Actuals for 2011</P><P>Budget and Forecast for 2012</P><P></P><P>I want to compare 2011 Budget versus Forecast so there wouldn't be a variance calculation for 2010 - so I want to show only Actuals; however for 2011 and 2012 I want to calculate the variance between actual sales and the 2011 Budget.&nbsp; Is it possible - if my scenario makes sense!?</P><P></P><P>Thanks</P><P>C</P></BODY></HTML> Tue, 27 Nov 2012 15:28:10 GMT https://community.qlik.com/t5/QlikView/Conditional-expression-based-on-dimension-value/m-p/471238#M488730 2012-11-27T15:28:10Z