Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field that is a text field in my SQL table. I went to great lengths to ensure this field gets assigned as text in the database. When I add it to my Qlikview report, some of the values are still showing as scientific notation. I load many other fields into the report and I just do a SELECT * FROM TableName. How can I LOAD the field as TEXT in the script and just call out the field(s) I want to make as text?
That is correct.
In the above script, the second load is concatenated to first and gets dropped. You need to use a 'No Concatenate' statement.
Thanks for pointing out, but the script above is SELECT * and not SELECT GLAccts... so in this case it isn't required anymore.
Best,
Sunny