topic Year on Year, Month on Month Variance in QlikView https://community.qlik.com/t5/QlikView/Year-on-Year-Month-on-Month-Variance/m-p/345403#M127742 <HTML><HEAD></HEAD><BODY><P>Hi, I need to dispaly Year on Year Variance, Month on Month Variance in my dashboard. </P><P></P><P>I have the following code for Month:</P><P>=sum(if(MEASURE_ID=50,NUMERATOR, if(MEASURE_ID=51,NUMERATOR,</P><P>if(MEASURE_ID=54,NUMERATOR, if(MEASURE_ID=56,NUMERATOR, if(MEASURE_ID=55,NUMERATOR,</P><P>if(MEASURE_ID=61,NUMERATOR, if(MEASURE_ID=53,NUMERATOR))))))))</P><P></P><P>and it returns this view:</P><P></P><P><IMG src="https://community.qlik.com/" /></P><P></P><P>I have the following code for Year:</P><P>=sum({$&lt;Month=&gt;}(if(MEASURE_ID=50,NUMERATOR, if(MEASURE_ID=51,NUMERATOR,</P><P>if(MEASURE_ID=54,NUMERATOR, if(MEASURE_ID=56,NUMERATOR, if(MEASURE_ID=55,NUMERATOR,</P><P>if(MEASURE_ID=61,NUMERATOR, if(MEASURE_ID=53,NUMERATOR)))))))))</P><P></P><P>and it returns this view:</P><P><IMG src="https://community.qlik.com/" /></P><P></P><P>I now need to display Year on Year Variance and Month on Month Variance. Please help</P></BODY></HTML> Sat, 09 Jun 2012 10:04:59 GMT 2012-06-09T10:04:59Z Year on Year, Month on Month Variance https://community.qlik.com/t5/QlikView/Year-on-Year-Month-on-Month-Variance/m-p/345403#M127742 <HTML><HEAD></HEAD><BODY><P>Hi, I need to dispaly Year on Year Variance, Month on Month Variance in my dashboard. </P><P></P><P>I have the following code for Month:</P><P>=sum(if(MEASURE_ID=50,NUMERATOR, if(MEASURE_ID=51,NUMERATOR,</P><P>if(MEASURE_ID=54,NUMERATOR, if(MEASURE_ID=56,NUMERATOR, if(MEASURE_ID=55,NUMERATOR,</P><P>if(MEASURE_ID=61,NUMERATOR, if(MEASURE_ID=53,NUMERATOR))))))))</P><P></P><P>and it returns this view:</P><P></P><P><IMG src="https://community.qlik.com/" /></P><P></P><P>I have the following code for Year:</P><P>=sum({$&lt;Month=&gt;}(if(MEASURE_ID=50,NUMERATOR, if(MEASURE_ID=51,NUMERATOR,</P><P>if(MEASURE_ID=54,NUMERATOR, if(MEASURE_ID=56,NUMERATOR, if(MEASURE_ID=55,NUMERATOR,</P><P>if(MEASURE_ID=61,NUMERATOR, if(MEASURE_ID=53,NUMERATOR)))))))))</P><P></P><P>and it returns this view:</P><P><IMG src="https://community.qlik.com/" /></P><P></P><P>I now need to display Year on Year Variance and Month on Month Variance. Please help</P></BODY></HTML> Sat, 09 Jun 2012 10:04:59 GMT https://community.qlik.com/t5/QlikView/Year-on-Year-Month-on-Month-Variance/m-p/345403#M127742 2012-06-09T10:04:59Z