Discussion board where members can get started with QlikView.
I have numbers like
What format code should I use so that no digits are lost. Also, there are nulls in some rows and I want to replace them with 0.
Please help me understand how the format codes work. I tried using '##0.#' but it trimmed the decimals to 1 decimal place.
Are you expecting this from dummy data?
For this, I used like below
LOAD Dummy, SubField(Dummy,'.',1) as Output1, Round(Dummy) as Output2 Inline [
Sorry, This time not clear to me, Would you explain the result set as you required
You don't need Num() function and any format code.
However QlikView accepts mas 14 Digits (12345678,12345678 -> 12345678,123456)
If You want chenge Null to 0, in script :
Set NullValue = '0';
Thanks everyone. I think to get my desired solution I can use the ALT function.
But I am trying to understand how # and 0 work in number format. Do I need to put as many # as number of possible decimal places in any of the numbers to get the numbers as is without losing any digit?
eg) num(123456.123456789, '######.#########')
Is this correct?
Not required, simply u can use like below in text object.
using alt can replace null as 0
Num# will return actual number
Hope this helps you