topic Re: Non Zero Expression in QlikView

Non Zero Expression

kunkumnaveen — Tue, 22 Mar 2022 05:25:35 GMT

HI All,

I need a suggestion in framing a expression which should also pick a non zero max value if both zero and non values exist for a selection,

Incase if only one value exist (zero or non zero ) it should show that value

Sample data:

If I select date 20220414 the max value is 0 but it also got non zero values hence it should show max non zero value in a KPI

it should show the highlighted value instead of zero value

Can any suggestion plz in writing the expression

hic — Tue, 22 Mar 2022 08:48:02 GMT

Try

Max({<Difference-={0.000}>} Difference)

kunkumnaveen — Tue, 22 Mar 2022 09:04:15 GMT

Hi Henric,

Thank You for your reply , the above expression picks non zero max value when there is zero and Non zero values exist for a selection

The expression should also show up zero values too if there is only one value

For example :

if I select a date which has only zero value it is showing null in KPI

hic — Tue, 22 Mar 2022 09:17:35 GMT

Try

If(Count(distinct Difference)=1,Only(Difference),Max({<Difference-={0.000}>} Difference))