Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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.

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

Highlighted
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.