topic COMPARING PERIOD VALUES AND CALCULATING VARIANCES in QlikView https://community.qlik.com/t5/QlikView/COMPARING-PERIOD-VALUES-AND-CALCULATING-VARIANCES/m-p/204198#M61203 <HTML><HEAD></HEAD><BODY><P>think the expression is missing ... :</P><P></P><PRE class="jive_text_macro jive_macro_quote" jivemacro="quote"><BR />johanlun wrote:<BR /><BR />and the following expression:<BR /><BR /><BR /><BR /><BR /><BR /><B><BR />COUNT<BR /></B><BR /></PRE><BR /><BR /> <P></P></BODY></HTML> Thu, 07 Jan 2010 13:40:24 GMT Anonymous 2010-01-07T13:40:24Z COMPARING PERIOD VALUES AND CALCULATING VARIANCES https://community.qlik.com/t5/QlikView/COMPARING-PERIOD-VALUES-AND-CALCULATING-VARIANCES/m-p/204197#M61202 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have done a pivot table that I populate with "Current Period" and "Previous Period" values, using the following Calculated dimension:</P><P>=IF(MATCH(SELECTED_MONTH-PREVIOUS_MONTH,0,1),PREVIOUS_MONTH)</P><P>and the following expression:</P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold">COUNT</P><B></B><P style="font-weight: bold"></P><P></P><P>I need to calculate and display the variance between SELECTED_MONTH and PREVIOUS_MONTH as well as the percentage variance.</P><P>Would appreciate any assistance.</P>(<B>Location</B>)<BR /><BR /> <BR /><BR /> <BR /><BR /></BODY></HTML> Thu, 07 Jan 2010 12:29:16 GMT https://community.qlik.com/t5/QlikView/COMPARING-PERIOD-VALUES-AND-CALCULATING-VARIANCES/m-p/204197#M61202 2010-01-07T12:29:16Z COMPARING PERIOD VALUES AND CALCULATING VARIANCES https://community.qlik.com/t5/QlikView/COMPARING-PERIOD-VALUES-AND-CALCULATING-VARIANCES/m-p/204198#M61203 <HTML><HEAD></HEAD><BODY><P>think the expression is missing ... :</P><P></P><PRE class="jive_text_macro jive_macro_quote" jivemacro="quote"><BR />johanlun wrote:<BR /><BR />and the following expression:<BR /><BR /><BR /><BR /><BR /><BR /><B><BR />COUNT<BR /></B><BR /></PRE><BR /><BR /> <P></P></BODY></HTML> Thu, 07 Jan 2010 13:40:24 GMT https://community.qlik.com/t5/QlikView/COMPARING-PERIOD-VALUES-AND-CALCULATING-VARIANCES/m-p/204198#M61203 Anonymous 2010-01-07T13:40:24Z COMPARING PERIOD VALUES AND CALCULATING VARIANCES https://community.qlik.com/t5/QlikView/COMPARING-PERIOD-VALUES-AND-CALCULATING-VARIANCES/m-p/204199#M61204 <HTML><HEAD></HEAD><BODY><P>The expression is:</P><P>count(source)</P></BODY></HTML> Thu, 07 Jan 2010 13:48:22 GMT https://community.qlik.com/t5/QlikView/COMPARING-PERIOD-VALUES-AND-CALCULATING-VARIANCES/m-p/204199#M61204 2010-01-07T13:48:22Z