Text function is not working

[Sakura]

I have used TEXT function for one field and it worked fantastically but for some other field it is not working.

I am importing data from excel. I have text and numeric values in the field. For numeric values, the Qlik is appending zeros after decimal places which I do not want.

Values

9M0007

0.23

100

UMKK001

For text values it returns perfectly, but for others

0.230000

100.000000

Kindly help!

[Anil_Babu_Samineni]

Can you make it clear with inline memory and result set needed?

[krishnacbe]

Please find the attached sample. Text() function works.

[Sakura]

As I have mentioned, the TEXT function is working for me for other column. I am surprised myself how is it not working for other same type of column.

[marcus_sommer · Accepted solution]

Try it with something like:

alt(num(Values, '#,##0.#####'), text(Values)) as Values

- Marcus

[Sakura]

This is what I came up with!

if(Isnum([Value]), Round([Value],0.01),[Value])

Thank you Marcus for the expression. I have tried your expression but it was avoiding some values I am not sure how. The excel file which I am using to import the data is really big so that might be causing the issues. I am just guessing.