topic Re: Calculate variance in QlikView

Calculate variance

Fri, 14 Dec 2012 12:13:19 GMT

I need to calculate variance of inprogress task where actual value has crossed 90% of estimate value. i've attached the sample file

fields to show:

taskname, percentage complted, actual value, estimated value , calculated variance

Re: Calculate variance

Anonymous — Fri, 14 Dec 2012 12:24:27 GMT

if(Sum([Act Value])>(Sum([Est Value])*0.9),Sum([Est Value])/Sum([Act Value]))

Re: Calculate variance

Fri, 14 Dec 2012 12:53:55 GMT

Thanks for replying.... this is calculating variance for all all records...I want to see only those records in which actual value has crossed 90% of estimate value.... can i get the variance only for those records....

Re: Calculate variance

Anonymous — Fri, 14 Dec 2012 13:13:40 GMT

The 'if(Sum([Act Value])>(Sum([Est Value])*0.9)...' test is intended to make that restriction for you, with nothing generatd if that condition is not meet. I may be missing the point though.

Jonathan

Re: Calculate variance

Fri, 14 Dec 2012 14:27:26 GMT

thanks i think it shud work....

Re: Calculate variance

Anonymous — Thu, 20 Dec 2012 11:30:29 GMT

Is this answered now ? I think you marked the wrong post as a helpful answer (i.e. one of your questions)

Jonathan

Re: Calculate variance

Thu, 20 Dec 2012 12:39:16 GMT

thanks yes it worked for me....