topic Re: column Total as Percentage based on Expression Total in QlikView

column Total as Percentage based on Expression Total

Mon, 07 Jul 2014 13:53:47 GMT

Hi all

By using the expression

Rangesum ((avg(if([TEST VALUE]>90 and [TEST VALUE]<=100 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]>80 and [TEST VALUE]<=90 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]>70 and [TEST VALUE]<=80 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]>65 and [TEST VALUE]<=70 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]>30 and [TEST VALUE]<=65 , [TEST VALUE]))*Avg(Weight)/100) +
(avg(if([TEST VALUE]<30 , [TEST VALUE]))*Avg(Weight)/100)

I am getting values

Employee Band	Total #
I	56.10
II	44.40
III	45.88
IV	43.84
V	43.94
VI	43.88
	278.05

Now i want the Total value ie 278.05 for the next expression to calculate the percentage of utilization for the employee band

for example for band 1 i need to display 56.10/278.05 *100 =20.18

Please advice

Thanks in advance

Re: column Total as Percentage based on Expression Total

Anonymous — Mon, 07 Jul 2014 14:19:18 GMT

Hello Villa,

try like this. create another field like this in ur script.

(Total#/Sum(Total#))*100 AS Band_perc

Re: column Total as Percentage based on Expression Total

Mon, 07 Jul 2014 14:22:27 GMT

HI Venkat

The column TOTAL# is a result of the above script and its not a direct value from source

Re: column Total as Percentage based on Expression Total

Mon, 07 Jul 2014 15:09:22 GMT

Any Sollutions

Re: column Total as Percentage based on Expression Total

Anonymous — Mon, 07 Jul 2014 15:15:03 GMT

You are getting value for total field na, u can write same logic on that expression...

Re: column Total as Percentage based on Expression Total

vardhancse — Mon, 07 Jul 2014 15:24:54 GMT

as its a expression total, i think we can not use that for calculation