topic Re: Replacing dash with empty in table in App Development

Replacing dash with empty in table

jpjust — Fri, 07 May 2021 16:48:58 GMT

All,

I have a simple table.

User App User Access last used NA User Access Last used EMEA

User A Test 03/21/2020 -

User B Test A - 05/04/2021

I want to fill the dash with blank. To achieve that I tried using the below expression in the app but did not take the effect.

=if(isnull([User Access Last Used NA]),'',timeStamp([User Access Last Used NA], 'DD/MM/YYYY'))

I tried some thing like this and did not work either.

=if([User Access Last Used]='-','',timeStamp([User Access Last Used], 'DD/MM/YYYY'))

Can some one please take a look and advice?

Thanks

Re: Replacing dash with empty in table

JuanGerardo — Fri, 07 May 2021 17:05:04 GMT

Hi, you can convert those "dash" values to nulls, probably the best way to ignore those values in calculations:

NullAsValue [User Access Last Used NA];

Set NullValue = '-';

LOAD [User Access Last Used NA],

other fields

from yourdatasource;

Re: Replacing dash with empty in table

jpjust — Fri, 07 May 2021 18:23:32 GMT

Thanks Juan for that idea. But unfortunately that did not work.

Can't we do it in the chart level?

Re: Replacing dash with empty in table

JuanGerardo — Sun, 09 May 2021 12:32:51 GMT

I thought you want to omit those values from your tables. In case you want to replace '-' (dash symbol) in your charts, you have to take into account it is used for nulls and missing values, so you will have to check both conditions, for example:

If(IsNull(EmptyIsNull([User Access Last Used NA])), '', [User Access Last Used NA])