topic Replace Nulls for Dimension and Measure values in QlikView https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865231#M989368 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I want to populate <SPAN style="color: #ff0000;"><STRONG>0</STRONG></SPAN> values for NULLs of measure SAL.</P><P>But want to keep<STRONG> <SPAN style="color: #ff0000;">-</SPAN></STRONG> as it is.</P><P></P><P>How to achieve this? Thanks in advance.<IMG alt="Populate_Null_Dim_Measure.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92751_Populate_Null_Dim_Measure.png" style="height: auto;" /></P><P></P><P><STRONG>Required output:</STRONG></P><P><STRONG><IMG alt="Required Output.JPG" class="jive-image image-2" src="/legacyfs/online/92752_Required Output.JPG" style="height: auto;" /></STRONG></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT qlikviewwizard 2020-11-20T18:02:30Z Replace Nulls for Dimension and Measure values https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865231#M989368 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I want to populate <SPAN style="color: #ff0000;"><STRONG>0</STRONG></SPAN> values for NULLs of measure SAL.</P><P>But want to keep<STRONG> <SPAN style="color: #ff0000;">-</SPAN></STRONG> as it is.</P><P></P><P>How to achieve this? Thanks in advance.<IMG alt="Populate_Null_Dim_Measure.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92751_Populate_Null_Dim_Measure.png" style="height: auto;" /></P><P></P><P><STRONG>Required output:</STRONG></P><P><STRONG><IMG alt="Required Output.JPG" class="jive-image image-2" src="/legacyfs/online/92752_Required Output.JPG" style="height: auto;" /></STRONG></P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865231#M989368 qlikviewwizard 2020-11-20T18:02:30Z Re: Replace Nulls for Dimension and Measure values https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865232#M989369 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/92749_Capture.PNG" style="height: auto;" /></P><P></P><P>Use Missing Symbol on Presentation Tab.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92748_Capture.PNG" style="height: 533px; width: 620px;" /></P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 14 Jul 2015 01:47:53 GMT https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865232#M989369 sunny_talwar 2015-07-14T01:47:53Z Re: Replace Nulls for Dimension and Measure values https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865233#M989370 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/sunindia">sunindia</A></STRONG></P><P>Yes. This is what I am looking for.</P><P>Thank you so much.</P></BODY></HTML> Tue, 14 Jul 2015 01:51:28 GMT https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865233#M989370 qlikviewwizard 2015-07-14T01:51:28Z Re: Replace Nulls for Dimension and Measure values https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865234#M989371 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Glad I was able to help.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 14 Jul 2015 01:52:02 GMT https://community.qlik.com/t5/QlikView/Replace-Nulls-for-Dimension-and-Measure-values/m-p/865234#M989371 sunny_talwar 2015-07-14T01:52:02Z