topic Pivot Null to Zero in App Development

topic Pivot Null to Zero in App Development https://community.qlik.com/t5/App-Development/Pivot-Null-to-Zero/m-p/1578792#M42212 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject"><DIV class="MessageSubjectIcons "><DIV class="lia-message-subject">Pivot table Null value QlikSense</DIV></DIV></DIV></DIV></DIV><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><TABLE><TBODY><TR><TD>Compliance</TD><TD>CAT</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>TOTAL</TD><TD>CAT-1</TD><TD>CAT-2</TD><TD>CAT-3</TD></TR><TR><TD>TOTAL</TD><TD>10</TD><TD>3</TD><TD>4</TD><TD>3</TD></TR><TR><TD>Approved</TD><TD>5</TD><TD>---</TD><TD>4</TD><TD>1</TD></TR><TR><TD>Not Approved</TD><TD>3</TD><TD>2</TD><TD>---</TD><TD>1</TD></TR><TR><TD>Not Applicable</TD><TD>2</TD><TD>1</TD><TD>---</TD><TD>1</TD></TR></TBODY></TABLE><P> </P><P>Above is a Pivot table  where </P><P>1- Compliance is Dimension -(ROW)</P><P>2- CAT is Dimension-(Column)</P><P>3-Count of Compliance is the measure </P><P>How can I eliminate the (--) for null and replace with ('0") Zero instead in my Pivot table.</P></DIV></DIV> Sat, 16 Nov 2024 20:54:04 GMT vpanchuda 2024-11-16T20:54:04Z Pivot Null to Zero https://community.qlik.com/t5/App-Development/Pivot-Null-to-Zero/m-p/1578792#M42212 <DIV class="topic-subject-wrapper"><DIV class="lia-message-subject lia-component-message-view-widget-subject"><DIV class="MessageSubject"><DIV class="MessageSubjectIcons "><DIV class="lia-message-subject">Pivot table Null value QlikSense</DIV></DIV></DIV></DIV></DIV><DIV class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"><DIV class="lia-message-body-content"><TABLE><TBODY><TR><TD>Compliance</TD><TD>CAT</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD>TOTAL</TD><TD>CAT-1</TD><TD>CAT-2</TD><TD>CAT-3</TD></TR><TR><TD>TOTAL</TD><TD>10</TD><TD>3</TD><TD>4</TD><TD>3</TD></TR><TR><TD>Approved</TD><TD>5</TD><TD>---</TD><TD>4</TD><TD>1</TD></TR><TR><TD>Not Approved</TD><TD>3</TD><TD>2</TD><TD>---</TD><TD>1</TD></TR><TR><TD>Not Applicable</TD><TD>2</TD><TD>1</TD><TD>---</TD><TD>1</TD></TR></TBODY></TABLE><P> </P><P>Above is a Pivot table  where </P><P>1- Compliance is Dimension -(ROW)</P><P>2- CAT is Dimension-(Column)</P><P>3-Count of Compliance is the measure </P><P>How can I eliminate the (--) for null and replace with ('0") Zero instead in my Pivot table.</P></DIV></DIV> Sat, 16 Nov 2024 20:54:04 GMT https://community.qlik.com/t5/App-Development/Pivot-Null-to-Zero/m-p/1578792#M42212 vpanchuda 2024-11-16T20:54:04Z Re: Pivot Null to Zero https://community.qlik.com/t5/App-Development/Pivot-Null-to-Zero/m-p/1578842#M42222 <P><SPAN>please try</SPAN></P><P> </P><P><SPAN>Replace(Measure,'---','0')</SPAN></P> Fri, 10 May 2019 09:06:47 GMT https://community.qlik.com/t5/App-Development/Pivot-Null-to-Zero/m-p/1578842#M42222 sunilkumarqv 2019-05-10T09:06:47Z