topic Comparing expressions in QlikView https://community.qlik.com/t5/QlikView/Comparing-expressions/m-p/1220917#M872527 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a pivot table with many vertical expressions, like in the attached sample, and I need to compute a percent for each expression, to compare 2015 vs 2016 values, like this:</P><P><IMG alt="img1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143362_img1.png" style="height: auto;" /></P><P>Next step is to have another table with two dimmensions: 1. YTD (jan to last month) and current month and 2. 2015, 2016, %:</P><P><IMG alt="img1.png" class="jive-image image-2" height="132" src="https://community.qlik.com/legacyfs/online/143363_img1.png" style="height: 132px; width: 810.297px;" width="810" /> </P><P>How can I do this in QlikView?</P><P></P><P>Thank You!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT simonagheo 2020-11-25T16:16:04Z Comparing expressions https://community.qlik.com/t5/QlikView/Comparing-expressions/m-p/1220917#M872527 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a pivot table with many vertical expressions, like in the attached sample, and I need to compute a percent for each expression, to compare 2015 vs 2016 values, like this:</P><P><IMG alt="img1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143362_img1.png" style="height: auto;" /></P><P>Next step is to have another table with two dimmensions: 1. YTD (jan to last month) and current month and 2. 2015, 2016, %:</P><P><IMG alt="img1.png" class="jive-image image-2" height="132" src="https://community.qlik.com/legacyfs/online/143363_img1.png" style="height: 132px; width: 810.297px;" width="810" /> </P><P>How can I do this in QlikView?</P><P></P><P>Thank You!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Comparing-expressions/m-p/1220917#M872527 simonagheo 2020-11-25T16:16:04Z