topic Re: Hiding Column in Pivot Table in QlikView

topic Re: Hiding Column in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Hiding-Column-in-Pivot-Table/m-p/1222643#M872101 <HTML><HEAD></HEAD><BODY><P>May be using Dual() function</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143397_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 09 Nov 2016 14:14:31 GMT sunny_talwar 2016-11-09T14:14:31Z Hiding Column in Pivot Table https://community.qlik.com/t5/QlikView/Hiding-Column-in-Pivot-Table/m-p/1222642#M872100 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P></P><P>Please find the below data</P><P></P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" width="344"><TBODY><TR><TD class="xl63" height="17" width="64">id </TD><TD class="xl63" width="64">Type</TD><TD class="xl63" width="64">name </TD><TD class="xl63" width="64">salary</TD><TD class="xl63" width="88">sales</TD></TR><TR><TD align="right" height="17">1</TD><TD class="xl63">A</TD><TD class="xl63">AAA</TD><TD align="right">100</TD><TD align="right">1000</TD></TR><TR><TD align="right" height="17">2</TD><TD class="xl63">A</TD><TD class="xl63">AAA</TD><TD align="right">200</TD><TD align="right">2000</TD></TR><TR><TD align="right" height="17">3</TD><TD class="xl63">B</TD><TD class="xl63">BBB</TD><TD align="right">300</TD><TD align="right">3000</TD></TR><TR><TD align="right" height="17">4</TD><TD class="xl63">B</TD><TD class="xl63">CCC</TD><TD align="right">300</TD><TD align="right">4000</TD></TR><TR><TD align="right" height="17">5</TD><TD class="xl63">C</TD><TD class="xl63">DDD</TD><TD align="right">355</TD><TD align="right">5000</TD></TR><TR><TD align="right" height="17">6</TD><TD class="xl63">D</TD><TD class="xl63">EEE</TD><TD align="right">400</TD><TD align="right">60000</TD></TR><TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-size: 13.3333px;">Without using macro </SPAN>i need output like below in Pivot Chart .I want to hide dimension Id.</P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" width="392"><TBODY><TR><TD class="xl65" height="17" width="98">Type</TD><TD class="xl65" style="border-left: none;" width="98">name</TD><TD class="xl65" style="border-left: none;" width="98">sum(salary)</TD><TD class="xl65" style="border-left: none;" width="98">sum(sales)</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;"> </TD><TD class="xl66" style="border-top: none;"> </TD><TD align="right" class="xl67" style="border-top: none;">300</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">3000</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">A</TD><TD class="xl68" style="border-top: none; border-left: none;">AAA</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">100</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1000</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">A</TD><TD class="xl68" style="border-top: none; border-left: none;">AAA</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">200</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2000</TD></TR></TBODY></TABLE><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Hiding-Column-in-Pivot-Table/m-p/1222642#M872100 2020-11-25T16:16:04Z Re: Hiding Column in Pivot Table https://community.qlik.com/t5/QlikView/Hiding-Column-in-Pivot-Table/m-p/1222643#M872101 <HTML><HEAD></HEAD><BODY><P>May be using Dual() function</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143397_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 09 Nov 2016 14:14:31 GMT https://community.qlik.com/t5/QlikView/Hiding-Column-in-Pivot-Table/m-p/1222643#M872101 sunny_talwar 2016-11-09T14:14:31Z Re: Hiding Column in Pivot Table https://community.qlik.com/t5/QlikView/Hiding-Column-in-Pivot-Table/m-p/1222644#M872102 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P></BODY></HTML> Wed, 09 Nov 2016 15:18:20 GMT https://community.qlik.com/t5/QlikView/Hiding-Column-in-Pivot-Table/m-p/1222644#M872102 2016-11-09T15:18:20Z