Expression to Ignore Zero Values

[kishoreravi1983]

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]

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]

Thank you Vamsee