topic Set Analysis PY Value in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-PY-Value/m-p/742437#M265087 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this expression in a pivot table to get the previous year sales:</P><P></P><P>=sum(aggr(sum({&lt;MonthYear,YearMonth={"$(=YearMonth-100)"}&gt;}SalesValue)/100, Product,Region))</P><P></P><P>it works fine until I select, for example, 2 YearMonth!?</P><P></P><P>I think it's because there are values that exists in one YearMonth, but not in the other, so their is nulls in the value columns...</P><P></P><P>Any suggestions?</P><P></P><P>Regards,</P><P></P><P>Francisco</P></BODY></HTML> Fri, 28 Nov 2014 10:54:24 GMT 2014-11-28T10:54:24Z Set Analysis PY Value https://community.qlik.com/t5/QlikView/Set-Analysis-PY-Value/m-p/742437#M265087 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this expression in a pivot table to get the previous year sales:</P><P></P><P>=sum(aggr(sum({&lt;MonthYear,YearMonth={"$(=YearMonth-100)"}&gt;}SalesValue)/100, Product,Region))</P><P></P><P>it works fine until I select, for example, 2 YearMonth!?</P><P></P><P>I think it's because there are values that exists in one YearMonth, but not in the other, so their is nulls in the value columns...</P><P></P><P>Any suggestions?</P><P></P><P>Regards,</P><P></P><P>Francisco</P></BODY></HTML> Fri, 28 Nov 2014 10:54:24 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-PY-Value/m-p/742437#M265087 2014-11-28T10:54:24Z