topic Re: Text function is not working in QlikView

Text function is not working

Sakura — Fri, 05 Jan 2018 14:11:49 GMT

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!

Re: Text function is not working

Anil_Babu_Samineni — Fri, 05 Jan 2018 14:16:05 GMT

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

Re: Text function is not working

krishnacbe — Fri, 05 Jan 2018 15:29:10 GMT

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

Re: Text function is not working

Sakura — Mon, 08 Jan 2018 15:38:49 GMT

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.

Re: Text function is not working

marcus_sommer — Mon, 08 Jan 2018 16:02:17 GMT

Try it with something like:

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

- Marcus

Re: Text function is not working

Sakura — Mon, 08 Jan 2018 16:12:58 GMT

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.