topic Re: Does Before and After function only work with Horizontal Pivot Tables? in QlikView https://community.qlik.com/t5/QlikView/Does-Before-and-After-function-only-work-with-Horizontal-Pivot/m-p/969527#M332112 <HTML><HEAD></HEAD><BODY><P>May be you can use <STRONG>above</STRONG> expression in straight table.</P><P>=Above(Expression)</P><P></P><P>QV help:</P><P><IMG alt="Capture1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97910_Capture1.JPG" style="height: 95px; width: 620px;" /></P><P><IMG alt="Capture.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/97911_Capture.JPG" style="height: 78px; width: 620px;" /></P></BODY></HTML> Thu, 03 Sep 2015 15:56:51 GMT settu_periasamy 2015-09-03T15:56:51Z Does Before and After function only work with Horizontal Pivot Tables? https://community.qlik.com/t5/QlikView/Does-Before-and-After-function-only-work-with-Horizontal-Pivot/m-p/969525#M332110 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Does Before and After function only work with Horizontal Pivot Tables?</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97900_Capture.JPG" style="height: 127px; width: 620px;" /></P><P></P><P>In the above example you can see the Before function for Sales in red colour working, but as soon as I pivot the table it stops working in the copy of the table below it.</P><P></P><P>Is this the case?</P></BODY></HTML> Thu, 03 Sep 2015 15:44:06 GMT https://community.qlik.com/t5/QlikView/Does-Before-and-After-function-only-work-with-Horizontal-Pivot/m-p/969525#M332110 jblomqvist 2015-09-03T15:44:06Z Re: Does Before and After function only work with Horizontal Pivot Tables? https://community.qlik.com/t5/QlikView/Does-Before-and-After-function-only-work-with-Horizontal-Pivot/m-p/969526#M332111 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P>Please See:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-8205">Missing Manual - Before() and After()</A></P></BODY></HTML> Thu, 03 Sep 2015 15:51:10 GMT https://community.qlik.com/t5/QlikView/Does-Before-and-After-function-only-work-with-Horizontal-Pivot/m-p/969526#M332111 Anonymous 2015-09-03T15:51:10Z Re: Does Before and After function only work with Horizontal Pivot Tables? https://community.qlik.com/t5/QlikView/Does-Before-and-After-function-only-work-with-Horizontal-Pivot/m-p/969527#M332112 <HTML><HEAD></HEAD><BODY><P>May be you can use <STRONG>above</STRONG> expression in straight table.</P><P>=Above(Expression)</P><P></P><P>QV help:</P><P><IMG alt="Capture1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/97910_Capture1.JPG" style="height: 95px; width: 620px;" /></P><P><IMG alt="Capture.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/97911_Capture.JPG" style="height: 78px; width: 620px;" /></P></BODY></HTML> Thu, 03 Sep 2015 15:56:51 GMT https://community.qlik.com/t5/QlikView/Does-Before-and-After-function-only-work-with-Horizontal-Pivot/m-p/969527#M332112 settu_periasamy 2015-09-03T15:56:51Z