script from percentage fields

didierodayo — Tue, 17 Jan 2017 07:38:13 GMT

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

Re: script from percentage fields

Anonymous — Tue, 17 Jan 2017 08:07:47 GMT

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!

topic script from percentage fields in QlikView

script from percentage fields

Re: script from percentage fields