script from percentage fields

[didierodayo]

Hello ,

I have so issues with the fields below. I need to write the following 2 calculations based on the Qlikview fields below. I need the script for the load and expression on a table. The issues is I need the result to return a percentage value.

1-             AULvl + ((ENLvl - AULvl ) x avg(Levels))

  2-              ENLvl + ((100-ENLvl ) x avg(Levels))

Thanks

[Anonymous · Accepted solution]

Hi,

See sample attached.

You can do the formatting in script i.e num(AULvl + ((ENLvl - AULvl ) * avg(Levels)),'#,##0%') as calc1

or on the front end.

Listbox properties > Number  > Override Doc Settings> select show in percent and the number format you want.

Hope this helps!