https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971291#M1220567 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/144616">@Learnerr</a>&nbsp;</P> <P>Kindly set the field value as below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Lakshminarayanan_J_0-1661171265029.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87169i251D29D67A91F6A5/image-size/medium?v=v2&amp;px=400" role="button" title="Lakshminarayanan_J_0-1661171265029.png" alt="Lakshminarayanan_J_0-1661171265029.png" /></span></P> <P>&nbsp;</P> <P>or&nbsp;</P> <P>Check the below link it will be helpful,</P> <P><A href="https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/NullAsValue.htm?_ga=2.22822971.1480648192.1661152056-441112385.1659426626" target="_blank">https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/NullAsValue.htm?_ga=2.22822971.1480648192.1661152056-441112385.1659426626</A></P> <P>&nbsp;</P> Mon, 22 Aug 2022 12:29:26 GMT Lakshminarayanan_J 2022-08-22T12:29:26Z https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971255#M1220561 <P>Hi all,</P> <P>&nbsp;</P> <P>I have a pivot table but i dont wanna see the blank values of my dimension. How can i ignore them .</P> <P>&nbsp;</P> <P>Regards</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Learnerr_1-1661167707342.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87164i56217A303C2318DE/image-size/medium?v=v2&amp;px=400" role="button" title="Learnerr_1-1661167707342.png" alt="Learnerr_1-1661167707342.png" /></span></P> <P>&nbsp;</P> Mon, 22 Aug 2022 11:25:59 GMT https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971255#M1220561 Learnerr 2022-08-22T11:25:59Z https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971261#M1220562 <P>Perhaps suppressing null values as shown below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="peter_brown_1-1661168073769.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87167i42A05F86A9A6BA53/image-size/medium?v=v2&amp;px=400" role="button" title="peter_brown_1-1661168073769.png" alt="peter_brown_1-1661168073769.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 22 Aug 2022 11:34:50 GMT https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971261#M1220562 BrunPierre 2022-08-22T11:34:50Z https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971264#M1220565 <P>Hi&nbsp;<A id="link_25" class="lia-link-navigation lia-page-link lia-user-name-link" href="https://community.qlik.com/t5/user/viewprofilepage/user-id/16737" target="_self" aria-label="View Profile of peter_brown" aria-describedby="userProfileCard-16737"><SPAN class="">Peter_brown</SPAN></A><SPAN>&nbsp;</SPAN></P> <P>&nbsp;</P> <P>Thanks for the info. It works.</P> <P>&nbsp;</P> <P>Have a nice day!</P> Mon, 22 Aug 2022 11:40:01 GMT https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971264#M1220565 Learnerr 2022-08-22T11:40:01Z https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971269#M1220566 <P>Cheers!</P> Mon, 22 Aug 2022 11:44:40 GMT https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971269#M1220566 BrunPierre 2022-08-22T11:44:40Z https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971291#M1220567 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/144616">@Learnerr</a>&nbsp;</P> <P>Kindly set the field value as below</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Lakshminarayanan_J_0-1661171265029.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/87169i251D29D67A91F6A5/image-size/medium?v=v2&amp;px=400" role="button" title="Lakshminarayanan_J_0-1661171265029.png" alt="Lakshminarayanan_J_0-1661171265029.png" /></span></P> <P>&nbsp;</P> <P>or&nbsp;</P> <P>Check the below link it will be helpful,</P> <P><A href="https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/NullAsValue.htm?_ga=2.22822971.1480648192.1661152056-441112385.1659426626" target="_blank">https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/NullAsValue.htm?_ga=2.22822971.1480648192.1661152056-441112385.1659426626</A></P> <P>&nbsp;</P> Mon, 22 Aug 2022 12:29:26 GMT https://community.qlik.com/t5/QlikView/Ignoring-Blank-Values-in-Pivot-Table/m-p/1971291#M1220567 Lakshminarayanan_J 2022-08-22T12:29:26Z