Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

To remove last zeros in a particular column

Hi Community,

How to  remove all the last zeros in a particular column like below.

Table:

Coulumn

50,

60,

400,

5050,

050,

Expected output is:

Column

5,

6,

4,

505,

05

Thank you

1 Solution

Accepted Solutions

Re: To remove last zeros in a particular column

=REPLACE(TRIM(replace(Column, '0', ' ')),' ',0)

1 Reply

Re: To remove last zeros in a particular column

=REPLACE(TRIM(replace(Column, '0', ' ')),' ',0)

Community Browser