Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Conditional expression based on dimension value

Hi,

Is it possible to only have a calculation execute when the dimension is above a given value?  As an example;

Years =  2010, 2011 and 2012

Actual Sales for 2010

Budget Forecast and Actuals for 2011

Budget and Forecast for 2012

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.  Is it possible - if my scenario makes sense!?

Thanks

C

Community Browser