insert % number by script

[Anonymous]

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

[Gysbert_Wassenaar]

LOAD

     ...some fields...,

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

FROM ....

[Anonymous]

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

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

[Gysbert_Wassenaar]

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

[Anonymous]

still doesn't work

[Anonymous]

What kind of not work ?

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

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[Colin-Albert]

To insert 3%, use 0.03 as the number.

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

[Anonymous]

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.