I want to store a via join created qlikview table into a text document. Unfortunately, it stores the numbers (which are sometimes really "small") in scientific notation. For statistical purposes I need those in normal notation, but could not figure out how to until now. Any ideas?
I'm not sure if I understand you correctly but these are "exactly" the figures I do not want to have. In your example scientific notation indicates high levels, my case is the opposite.
what is the value range of your numbers? And how would you like it to be displayed? Would fixed number of decimal places would be ok, like
num(VALUE,'#,#####',',','.') as VALUE
lowest value is:
it should be presented this way:
using the formatting argument in the num command produces an error. qlikview then does not export any value for the figures in scientific notation.
ok, I solved that temporarily exporting the data from a table box into excel. It would nevertheless be interesing how to solve this problem in the script for larger data!