topic Re: Expression to Ignore Zero Values in App Development

Expression to Ignore Zero Values

kishoreravi1983 — Sat, 16 Nov 2024 07:43:07 GMT

Hi All,

Can any one help me in correcting this expression.

I would want to filter Null values from AUD_DLY_CROSS_VAR_VAL

ITs and EXPRESSION:

=if ([Exchange]='Cross Rate','AUD_DLY_CROSS_VAR_VAL-={0.00}', 'AUD_DLY_YTD_VAR_VAL-={0.00}')

Have tried Suppressing Zero values in QlikSense but not working..

Please rewrite the exp if its wrong.

Thanks,

Ravi

vamsee — Tue, 04 Sep 2018 18:17:59 GMT

May be try

=if ([Exchange]='Cross Rate',IF(AUD_DLY_CROSS_VAR_VAL<>0, AUD_DLY_YTD_VAR_VAL))

You could also use only

Only({<[Exchange]={'Cross Rate'},AUD_DLY_CROSS_VAR_VAL-={0}, AUD_DLY_CROSS_VAR_VAL={'*'}>}AUD_DLY_CROSS_VAR_VAL)

kishoreravi1983 — Fri, 28 Sep 2018 04:39:09 GMT

Thank you Vamsee