Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
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)
Thank you Vamsee