https://community.qlik.com/t5/App-Development/Hide-Column-using-before-or-after-function-on-Pivot-Table/m-p/1688329#M52492 <P>I'm in a pivot table showing periods from some month,</P><P>Like this:</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2019-01 | 2019-02 | 2019-03</P><P>Column1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>Column2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>&nbsp;</P><P>If I use before function to show the sum 2+3 from Column2 using before(), then sum 1+2 from Column1 using after(), It will result 8.</P><P>I want to get this<STRONG> same result</STRONG> in a 2019-02 row but <STRONG>hiding 2019-01 column</STRONG>. It is posible??</P><P>If I hide it desappear&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:52:45 GMT solverproblems 2024-11-16T18:52:45Z https://community.qlik.com/t5/App-Development/Hide-Column-using-before-or-after-function-on-Pivot-Table/m-p/1688329#M52492 <P>I'm in a pivot table showing periods from some month,</P><P>Like this:</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2019-01 | 2019-02 | 2019-03</P><P>Column1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>Column2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>&nbsp;</P><P>If I use before function to show the sum 2+3 from Column2 using before(), then sum 1+2 from Column1 using after(), It will result 8.</P><P>I want to get this<STRONG> same result</STRONG> in a 2019-02 row but <STRONG>hiding 2019-01 column</STRONG>. It is posible??</P><P>If I hide it desappear&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:52:45 GMT https://community.qlik.com/t5/App-Development/Hide-Column-using-before-or-after-function-on-Pivot-Table/m-p/1688329#M52492 solverproblems 2024-11-16T18:52:45Z https://community.qlik.com/t5/App-Development/Hide-Column-using-before-or-after-function-on-Pivot-Table/m-p/1773537#M59907 <P>Did you solve this <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/110901">@solverproblems</a>&nbsp;?<BR />I have the same question.</P> Mon, 11 Jan 2021 22:07:24 GMT https://community.qlik.com/t5/App-Development/Hide-Column-using-before-or-after-function-on-Pivot-Table/m-p/1773537#M59907 ingridhusby17 2021-01-11T22:07:24Z https://community.qlik.com/t5/App-Development/Hide-Column-using-before-or-after-function-on-Pivot-Table/m-p/2140757#M92763 <P>Utilizzando il menu</P> <H2 id="anchor-3" tabindex="-1">Add-ons</H2> <P><SPAN class="ui_item">Data handling</SPAN>:</P> <UL> <LI> <P><SPAN class="ui_item">Include zero values</SPAN></P> </LI> </UL> Thu, 23 Nov 2023 12:10:17 GMT https://community.qlik.com/t5/App-Development/Hide-Column-using-before-or-after-function-on-Pivot-Table/m-p/2140757#M92763 brunos 2023-11-23T12:10:17Z