Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
kishoreravi1983
New Contributor III

Expression to Ignore Zero Values

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

2 Replies
Highlighted
vamsee
Valued Contributor

Re: Expression to Ignore Zero Values

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)

Highlighted
kishoreravi1983
New Contributor III

Re: Expression to Ignore Zero Values

Thank you Vamsee