Discussion board where members can get started with QlikView.
Ive got a couple of numbers ranging from 0.1 to 0.00001 in a excel-file. They are not formatted as numbers (due to the range).
I dont want the numbers to with a fixed format (0.10000 to 0.00001).
How can I deal with this in QW?
It works now with 4 decimals but with 5 it shows 4,6e-005 (0.00046).
Thanks in advance!
use NUM() Function.
Hope this helps.
This will allow you to show 10 digits after decimal point.
Forgot to say that Ive tested both Num() and Num# but both generates a error when I load.
Not sure of the english translation but something about "Trash-code after section".
the line looks like this;
Result as Num(GVResult),
the same with Solanki's tips...
Num(Result) as GVResult,
Still doesnt help all the way tho.
With just the Num(Result) as GVResult I got no change at all
With the formatting I just gets ##### instead of numbers...
If you are using this in Script then you must use in this fasion.
Num(Field_Name,'#,##0.0000000000') as Field_Name
If you want to use in dimension then just use.
If you want to use in chart then you must go to properties-> number -> and click on expression and click on Fixed to . Here type 10.
can u upload ur application.
Solanki: I tried both and if I just Fixed to All the numbers got 10 decimals (I only want the ones that needs it to have 10 decimals)
Gupta: Sorry, dont think it would help since its not in english
But its strange that there seem to be a limit with 5 decimals...4 shows OK even without Num()-function.
i want to knw where r u using this field.
if u r using it in pivot or straight table then expand the column containing this field.....becz #### is normally shown when the number contains many digits and thy don't fit in the column.so Expand ur column.