topic Re: Pivot table make a cell disappear , but value in it in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766446#M1699 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Did this help?</P></BODY></HTML> Mon, 08 Dec 2014 04:07:46 GMT Anonymous 2014-12-08T04:07:46Z Pivot table make a cell disappear , but value in it https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766444#M1697 <HTML><HEAD></HEAD><BODY><P><IMG alt="Pivot table (2).PNG.png" class="jive-image" src="/legacyfs/online/72629_Pivot table (2).PNG.png" style="width: 620px; height: 236px;" /></P><P>Here in this pivot table i want to make disappear those fields but value should be there inside how can we makeup using background color or any other way ...what is the expression for it and where we have to write.</P></BODY></HTML> Wed, 03 Dec 2014 11:56:47 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766444#M1697 Anonymous 2014-12-03T11:56:47Z Re: Pivot table make a cell disappear , but value in it https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766445#M1698 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Right click on the cell and choose Custom Cell Format. Then you can make text color the same as background color. This will hide the value but it will still be there. Is this what you wanted to do?</P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/72893_Capture.PNG.png" /></P></BODY></HTML> Fri, 05 Dec 2014 21:39:06 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766445#M1698 Anonymous 2014-12-05T21:39:06Z Re: Pivot table make a cell disappear , but value in it https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766446#M1699 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Did this help?</P></BODY></HTML> Mon, 08 Dec 2014 04:07:46 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766446#M1699 Anonymous 2014-12-08T04:07:46Z Re: Pivot table make a cell disappear ,  but value in it https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766447#M1700 <HTML><HEAD></HEAD><BODY><P>nope can u give me u r mail id i will send the full issue</P></BODY></HTML> Mon, 08 Dec 2014 04:13:36 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Pivot-table-make-a-cell-disappear-but-value-in-it/m-p/766447#M1700 Anonymous 2014-12-08T04:13:36Z