topic Pivot Table doesn't show 1.00 cells in Archived Groups https://community.qlik.com/t5/Archived-Groups/Pivot-Table-doesn-t-show-1-00-cells/m-p/1336282#M3693 <HTML><HEAD></HEAD><BODY><P>Got this issue where all cells with value = 1 are not displayed. The calculation is right and shown when hovering with mouse (grey popup).</P><P></P><P><IMG alt="Pivot-Bug.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172198_Pivot-Bug.png" style="height: 142px; width: 620px;" /></P><P></P><P>Qlik Sense Version is 3.2 SR3</P><P></P><P>Any help for this nasty thing?</P></BODY></HTML> Wed, 23 Jul 2025 14:48:52 GMT rbecher 2025-07-23T14:48:52Z Pivot Table doesn't show 1.00 cells https://community.qlik.com/t5/Archived-Groups/Pivot-Table-doesn-t-show-1-00-cells/m-p/1336282#M3693 <HTML><HEAD></HEAD><BODY><P>Got this issue where all cells with value = 1 are not displayed. The calculation is right and shown when hovering with mouse (grey popup).</P><P></P><P><IMG alt="Pivot-Bug.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172198_Pivot-Bug.png" style="height: 142px; width: 620px;" /></P><P></P><P>Qlik Sense Version is 3.2 SR3</P><P></P><P>Any help for this nasty thing?</P></BODY></HTML> Wed, 23 Jul 2025 14:48:52 GMT https://community.qlik.com/t5/Archived-Groups/Pivot-Table-doesn-t-show-1-00-cells/m-p/1336282#M3693 rbecher 2025-07-23T14:48:52Z Re: Pivot Table doesn't show 1.00 cells https://community.qlik.com/t5/Archived-Groups/Pivot-Table-doesn-t-show-1-00-cells/m-p/1336283#M3694 <HTML><HEAD></HEAD><BODY><P>Found a workaround!</P><P></P><P>Explicitly setting the text color of the expression to a value fixes this issue:</P><P></P><P>='#595959'</P></BODY></HTML> Wed, 02 Aug 2017 11:16:51 GMT https://community.qlik.com/t5/Archived-Groups/Pivot-Table-doesn-t-show-1-00-cells/m-p/1336283#M3694 rbecher 2017-08-02T11:16:51Z