topic Re: How to exclude or hide values in a report in QlikView https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109567#M759434 <HTML><HEAD></HEAD><BODY><P>can you provide expressions for more information</P></BODY></HTML> Wed, 22 Aug 2018 10:13:23 GMT gavinigovind452 2018-08-22T10:13:23Z How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109564#M759431 <HTML><HEAD></HEAD><BODY><P>I do not want to show the values 0.00 in my report.I have already used the option suppress null value but still I am getting them.How can I hide them?</P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/211500_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109564#M759431 trishita 2020-11-25T16:16:04Z Re: How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109565#M759432 <HTML><HEAD></HEAD><BODY><P>Null values are different from 0.00000 values. Null values only appear when a field has no data for that record, so naturally, the 0.000 is a value.</P><P></P><P>That said, in case this is a measure, it could as well be that these aren't zero values, but it is a result with lots of zeros after the decimal.</P><P></P><P>You could always do an If-check in your script on [Fuel per last ...] for checking if the value is 0. If it is zero, give it the value Null(). This will allow you to use the Suppress null values.</P><P></P><P>Example:</P><P>If([Fuel per last ...] =0, Null(), [Fuel per last ...])</P></BODY></HTML> Wed, 22 Aug 2018 09:53:43 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109565#M759432 timpoismans 2018-08-22T09:53:43Z Re: How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109566#M759433 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/211502_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" />Currently I tried the following codes</P><P>If([Fuel per last Noon] =0.000, Null(), [Fuel per last Noon]) and related but I got this value.Now I want to hide this whole row..what should I do?</P></BODY></HTML> Wed, 22 Aug 2018 10:11:58 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109566#M759433 trishita 2018-08-22T10:11:58Z Re: How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109567#M759434 <HTML><HEAD></HEAD><BODY><P>can you provide expressions for more information</P></BODY></HTML> Wed, 22 Aug 2018 10:13:23 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109567#M759434 gavinigovind452 2018-08-22T10:13:23Z Re: How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109568#M759435 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check suppress null value for [Fuel per last Noon] dimension .</P><P></P><P></P><P>Thanks,</P><P>Pooja</P></BODY></HTML> Wed, 22 Aug 2018 10:20:35 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109568#M759435 pooja_prabhu_n 2018-08-22T10:20:35Z Re: How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109569#M759436 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/246492">timpoismans</A>‌ I rearranged the dimensions and it is working fine.Thanks for your help</P></BODY></HTML> Wed, 22 Aug 2018 10:21:04 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109569#M759436 trishita 2018-08-22T10:21:04Z Re: How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109570#M759437 <HTML><HEAD></HEAD><BODY><P>You should be able to hide null values per expression in your table. If you hide them for each expression, the row with null values for each expression shouldn't show in the table.</P></BODY></HTML> Wed, 22 Aug 2018 10:26:23 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109570#M759437 timpoismans 2018-08-22T10:26:23Z Re: How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109571#M759438 <HTML><HEAD></HEAD><BODY><P>You're welcome!</P></BODY></HTML> Wed, 22 Aug 2018 10:26:57 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109571#M759438 timpoismans 2018-08-22T10:26:57Z Re: How to exclude or hide values in a report https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109572#M759441 <HTML><HEAD></HEAD><BODY><P>Hi Govind,</P><P>Thanks for the enquiry but the question is closed and answered.</P><P></P><P>Regards,</P><P>Trishita</P></BODY></HTML> Tue, 04 Sep 2018 07:48:04 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-or-hide-values-in-a-report/m-p/109572#M759441 trishita 2018-09-04T07:48:04Z