Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Highlighted
bunnyv123
Contributor II

Pivot table make a cell disappear , but value in it

Pivot table (2).PNG.png

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.

Tags (5)
3 Replies
morris70
Valued Contributor

Re: Pivot table make a cell disappear , but value in it

Hi

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?

Capture.PNG.png

morris70
Valued Contributor

Re: Pivot table make a cell disappear , but value in it

Hi

Did this help?

bunnyv123
Contributor II

Re: Pivot table make a cell disappear ,  but value in it

nope can u give me u r mail id i will send the full issue