Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kishoreravi1983
Contributor III
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

Labels (1)
2 Replies
vamsee
Specialist
Specialist

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
Contributor III
Contributor III
Author

Thank you Vamsee