https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590536#M43355 <P>Maybe use a rangesum or another rangefunction on your measure</P> Tue, 11 Jun 2019 14:42:51 GMT W4ld 2019-06-11T14:42:51Z https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590437#M43338 <P>Hello got a pivot table (check image below)<BR />the work-group <STRONG>IAG-Support</STRONG> doesn't have data for Feb, Mar, and April 2019<BR />is there a way to remove the '-' for null and make the cell blank?<BR /><BR /></P><P>in May for the Planned Man-Days I got Zero and I manage to change the text color to white when zero but not when null</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="evi.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13543i7591D3FE00996D07/image-size/large?v=v2&amp;px=999" role="button" title="evi.PNG" alt="evi.PNG" /></span></P> Tue, 11 Jun 2019 11:49:38 GMT https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590437#M43338 ali_hijazi 2019-06-11T11:49:38Z https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590468#M43343 Add +sum({1}0) to your measures Tue, 11 Jun 2019 13:12:58 GMT https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590468#M43343 Gysbert_Wassenaar 2019-06-11T13:12:58Z https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590530#M43353 didn't work Tue, 11 Jun 2019 14:30:28 GMT https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590530#M43353 ali_hijazi 2019-06-11T14:30:28Z https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590536#M43355 <P>Maybe use a rangesum or another rangefunction on your measure</P> Tue, 11 Jun 2019 14:42:51 GMT https://community.qlik.com/t5/App-Development/Null-symbol/m-p/1590536#M43355 W4ld 2019-06-11T14:42:51Z