Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Sakura
Contributor

Text function is not working

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!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Text function is not working

Try it with something like:

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

- Marcus

5 Replies

Re: Text function is not working

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: Text function is not working

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

Highlighted
Sakura
Contributor

Re: Text function is not working

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.

MVP & Luminary
MVP & Luminary

Re: Text function is not working

Try it with something like:

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

- Marcus

Sakura
Contributor

Re: Text function is not working

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.