topic Re: Num in the script in QlikView

Num in the script

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

hey all,

my question is

i have too field one has the value of 157 and the second is 16

I need to create a field on the script that will give me the exact number of 157/(16*10)=0.98125 not 0.98

hope you can help

‌

sunny_talwar — Wed, 02 Mar 2016 14:33:21 GMT

Not sure, but may be this:

Num(Field1/(Field2*10), '##.#########') as AnotherField

alexpanjhc — Wed, 02 Mar 2016 14:34:47 GMT

C1:

load * inline [

field1, field2

157,16

]

;

load *,

num(field1/(field2*10),'#.####') as newfield

resident C1;

drop table C1;

sunny_talwar — Wed, 02 Mar 2016 14:39:01 GMT

Using Alex‌'s example, it seems that without num() function seems to work the best:

C1:

load * inline [

field1, field2

157,16

];

LOAD field1/(field2*10) as newfield

resident C1;

Anonymous — Wed, 02 Mar 2016 14:41:15 GMT

Hi Mario,

Just define the format that you want for the new field. Like the examples below

Num(Field1/(Field2*10), '##.#########')

Num(Field1/(Field2*10), '##.#####')

Regards,

Nandha

bohravanraj — Wed, 02 Mar 2016 14:48:22 GMT

num(157/(16*10),'##.#####')