Discussion Board for collaboration related to QlikView App Development.
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.
For text values it returns perfectly, but for others
Go to Solution.
Try it with something like:
alt(num(Values, '#,##0.#####'), text(Values)) as Values
Can you make it clear with inline memory and result set needed?
Please find the attached sample. Text() function works.
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.
This is what I came up with!
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.