topic Re: How to remove trailing zeros in QlikView

How to remove trailing zeros

varunreddy — Tue, 09 May 2017 15:08:08 GMT

Hi All,

I have field A, which has values 1 & 0. We get data every month end. But for this month we got the values with trailing numbers (i.e. 1.00000000000000000000 and 0.000000000000000000).

Can anyone please help me in removing the trailing zeros?

Thanks in advance!

Cheers,

Re: How to remove trailing zeros

tresB — Tue, 09 May 2017 15:10:17 GMT

Try like:

SubField(A, '.',1) as NewA

Re: How to remove trailing zeros

sunny_talwar — Tue, 09 May 2017 15:11:20 GMT

How about

Num(A, '##')

Num(A, '##.')

Re: How to remove trailing zeros

Anil_Babu_Samineni — Tue, 09 May 2017 15:11:35 GMT

May be this?

SubField(FieldName, '.', 1)

FieldName * 1

FieldName * Avg(1)

Re: How to remove trailing zeros

varunreddy — Tue, 09 May 2017 15:39:23 GMT

Hi Sunny,

Thanks for the response. But I don't see any value associated to that date. I see '-'.

Re: How to remove trailing zeros

sunny_talwar — Tue, 09 May 2017 15:41:18 GMT

I don't see any value associated to that date. I see '-'.

To what date?

Re: How to remove trailing zeros

varunreddy — Tue, 09 May 2017 15:46:29 GMT

As I mentioned, every month we get the data. The values will be 0 and 1. But for this month I got trailing zeros (i.e. 1.00000000000000000 and 0.00000000000000000).

When I created the list box for field "A", I see 0 and 1.

Now I selected the date 2/28/2017, then I see the association for the field A (i.e. 0 and 1 with White background in the list box).

Now I selected the date 3/30/2017, then I see no association for the field A (i.e. 0 and 1 with Grey background in the list box).

This is after using Num(A, '##').

Re: How to remove trailing zeros

varunreddy — Tue, 09 May 2017 15:51:37 GMT

Hi All,

Thanks for the quick response.

Cheers,

Re: How to remove trailing zeros

stigchel — Tue, 09 May 2017 15:55:45 GMT

Maybe A is a string and /or your decimal separator is different and you need to use the Num# function? i.e.

num(num#( A, '#.#', '.' , ','),'##')