topic Re: How to add an additional column in pivot table. in QlikView https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623928#M229631 <HTML><HEAD></HEAD><BODY><P>Can you share your sample apps?</P><P>May be we can achieve by using Dimensionality and Set Analysis.</P></BODY></HTML> Tue, 11 Mar 2014 11:14:11 GMT MK_QSL 2014-03-11T11:14:11Z How to add an additional column in pivot table. https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623927#M229630 <HTML><HEAD></HEAD><BODY><P>We have a column in the Pivot table "TOTAL", which has both +ve and -ve values. Now we need an adjacent column which should only show +ve values from the TOTAL column and all the -ve values as 0.</P><P></P><P>Need help on how to do it.</P></BODY></HTML> Tue, 11 Mar 2014 11:12:16 GMT https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623927#M229630 2014-03-11T11:12:16Z Re: How to add an additional column in pivot table. https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623928#M229631 <HTML><HEAD></HEAD><BODY><P>Can you share your sample apps?</P><P>May be we can achieve by using Dimensionality and Set Analysis.</P></BODY></HTML> Tue, 11 Mar 2014 11:14:11 GMT https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623928#M229631 MK_QSL 2014-03-11T11:14:11Z Re: How to add an additional column in pivot table. https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623929#M229632 <HTML><HEAD></HEAD><BODY><P>you can copy the same column &amp; then add conditional expression.</P><P>One with &lt; 0</P><P>Other with &gt; 0</P></BODY></HTML> Tue, 11 Mar 2014 11:15:45 GMT https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623929#M229632 manojkulkarni 2014-03-11T11:15:45Z Re: How to add an additional column in pivot table. https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623930#M229633 <HTML><HEAD></HEAD><BODY><P>the TOTAL column is a a partial sum column. How to copy the same column ? Plz find below the screen shot <IMG alt="pivot (2).png" class="jive-image" src="/legacyfs/online/54673_pivot (2).png" style="width: 620px; height: 349px;" /></P></BODY></HTML> Tue, 11 Mar 2014 11:29:22 GMT https://community.qlik.com/t5/QlikView/How-to-add-an-additional-column-in-pivot-table/m-p/623930#M229633 2014-03-11T11:29:22Z