topic Re: How to ignore 0 values in QlikView

How to ignore 0 values

Vinod — Sat, 16 Nov 2024 03:11:47 GMT

Hi All,

In my straight table I want to display smallest 5 values but my denominator having some zero values,
How to remove/Ignore those zero values in expression.For your reference i have attached screenshot.

Thanks,
Vinod

Re: How to ignore 0 values

sunny_talwar — Tue, 25 Jun 2019 11:52:29 GMT

What expression are you using for Denominator?

Re: How to ignore 0 values

Chanty4u — Tue, 25 Jun 2019 17:59:57 GMT

you can use in denominator expression include below code

{<Field-={0}>}

Re: How to ignore 0 values

Vinod — Wed, 26 Jun 2019 05:15:02 GMT

Hi Sunny,

Please check my expression.

=SUM({<%KEY_DATE={">=$(=$(v_min_registration_date))<=$(=$(v_current_date_TARGET))"}>}[Monthly Target])

and I used [Monthly Target]-={0} within expression but it is not working.

Please suggest me other solution.

Thanks,

Vinod

Re: How to ignore 0 values

sunny_talwar — Wed, 26 Jun 2019 11:14:01 GMT

Sorry, but I forgot to ask this earlier, but what is your expression for Numerator? Also, you want to show this chart with three expressions? Result1, N, & D? And which rows would you want to show in this chart?

Re: How to ignore 0 values

Vinod — Thu, 27 Jun 2019 05:13:10 GMT

Hi Sunny,

Please check my expression.

=((sum({<History_Flag={'Y'}>}Overall)) + (count({<History_Flag={'N'},RF_Flag={'R'} >}VIN_NO)))
/ SUM({<%KEY_DATE={">=$(=$(v_min_registration_date))<=$(=$(v_current_date_TARGET))"}>}[Monthly Target])

Here Some of the Denominator Values are coming zero. How to exclude that all zero values and it should consider only non-zero.