topic Re: insert % number by script in QlikView

insert % number by script

Anonymous — Wed, 14 Jan 2015 09:12:35 GMT

Hello everyone,

I'm trying to figure out how to insert a number by scripts in% because if I enable the% value in the table, when I enter a number for example 3, the result is 300% and no 3%.

The script that I am trying to do is: num('','#,##0%') as input

But it is wrong. some help? thanks

Re: insert % number by script

Gysbert_Wassenaar — Wed, 14 Jan 2015 09:15:25 GMT

LOAD

...some fields...,

num(MyPercentageField/100,'#,##0%') as MyPercentageField

FROM ....

Re: insert % number by script

Anonymous — Wed, 14 Jan 2015 09:30:53 GMT

does not work, I did: num (input / 100, '#, ## 0%') as input.

I also tried using 'input/100' and even with " "

Re: insert % number by script

Gysbert_Wassenaar — Wed, 14 Jan 2015 09:38:56 GMT

Then the field input does not contain numbers. Use the num# function to create numbers from the string values.

Re: insert % number by script

Anonymous — Wed, 14 Jan 2015 09:48:39 GMT

still doesn't work

Re: insert % number by script

Anonymous — Wed, 14 Jan 2015 09:51:46 GMT

What kind of not work ?

What was the input value, what was your expected result and what did you get ?

Re: insert % number by script

Anonymous — Wed, 14 Jan 2015 10:00:30 GMT

when I type my input I get the same number without %. So if I enter 3 I get 3.

If I launch the script with Num # (input / 100, '#, ## 0%') as input I get error.

However if I write Num # ('input' / 100 '#, ## 0%') as input I get what I said.

Re: insert % number by script

Anonymous — Wed, 14 Jan 2015 12:27:47 GMT

for now I solved it this way: I put in my input table values (eg 4), then in my table where I perform linear calculations I inserted num ([Column Name] / 100, '#, # 0%') and it works, i get 4,00%.

I'm still trying to enter the percentage value in the table, if I can not solve I maintain the solution I found

Re: insert % number by script

Colin-Albert — Wed, 14 Jan 2015 12:33:53 GMT

To insert 3%, use 0.03 as the number.

When a number is formatted as % QlikView automatically multiplies the number by 100

Re: insert % number by script

Anonymous — Wed, 14 Jan 2015 12:42:29 GMT

yes, but it's frustrating to enter the number with a comma. I prefer something more immediate and at the moment the second solution is the one that is closest to my goal.