i am getting below results from a sql query in data load editor:
30
66.2%
78.98%
32.78
16.7
these all values with different formatting are part of a single field, hence the field returned from sql is in string format.
however, if i apply some filters on this field and suppose the result is(all integers like values):
30
43
51
then qlik shows the values as:
30.0
43
51
so my question is why it is appending decimal places in some values or why it is treating the filed as integer/number. i am explicitly converting this particular field into string via sql.
Also this issue is intermittent, sometimes it happens and sometimes it does not.(i have many fields like such, if happens randomly with any field)
Even after using text function in expression editor or in loading data through data load editor the results are same. Somehow the qlik data engine converts the value 30 to 30.0
let me know if anyone has faced this scenario or has solution to this condition
lets say the table name is XYZ and column name is ABC
1. Converting the column into text in qlik editor
Load
text(ABC) as ABC
;
SQL
select
ABC
from XYZ;
2. Appending space in the sql query:
LOAD
ABC
;
SQL
select
concat(' ',ABC) as ABC
from XYZ;
however both these approaches results in the same behavior.
I cannot use the approach suggested by you, because i have more than a million records in the database and it is continuously updating with new data every day.
