topic Re: pivot column in QlikView https://community.qlik.com/t5/QlikView/pivot-column/m-p/136789#M759357 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P>Num(Column(1)-Column(3),'$###,###.00')</P></BODY></HTML> Thu, 30 Aug 2018 16:05:46 GMT BalaBhaskar_Qlik 2018-08-30T16:05:46Z pivot column https://community.qlik.com/t5/QlikView/pivot-column/m-p/136788#M759356 <HTML><HEAD></HEAD><BODY><P>I have a pivot table like below. I would like to calculate the Margin$ difference of month 7 and 8, shows in the last column. How can I get the Margin$ value of month 7 and 8?</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212265_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/pivot-column/m-p/136788#M759356 adamjwchen 2020-11-25T16:16:04Z Re: pivot column https://community.qlik.com/t5/QlikView/pivot-column/m-p/136789#M759357 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P>Num(Column(1)-Column(3),'$###,###.00')</P></BODY></HTML> Thu, 30 Aug 2018 16:05:46 GMT https://community.qlik.com/t5/QlikView/pivot-column/m-p/136789#M759357 BalaBhaskar_Qlik 2018-08-30T16:05:46Z Re: pivot column https://community.qlik.com/t5/QlikView/pivot-column/m-p/136790#M759358 <HTML><HEAD></HEAD><BODY><P>May be by using dimensionality() function. Can you share your qvw file to work on if possible?</P></BODY></HTML> Thu, 30 Aug 2018 16:14:22 GMT https://community.qlik.com/t5/QlikView/pivot-column/m-p/136790#M759358 vishsaggi 2018-08-30T16:14:22Z Re: pivot column https://community.qlik.com/t5/QlikView/pivot-column/m-p/136791#M759359 <HTML><HEAD></HEAD><BODY><P>I tried column() function, it does not work for this case.</P></BODY></HTML> Fri, 31 Aug 2018 00:31:08 GMT https://community.qlik.com/t5/QlikView/pivot-column/m-p/136791#M759359 adamjwchen 2018-08-31T00:31:08Z