topic Re: How to write Expression for Variance in a Straight Table in QlikView

How to write Expression for Variance in a Straight Table

Anonymous — Wed, 24 Dec 2014 16:40:46 GMT

I have the below chart image 1, where I need to insert Variances for 2011-2012 & 2011-2013 in a way similar to image 2. any suggestions.

also how to make the boxes green and red according to +/- growth.

Many Thanks

Re: How to write Expression for Variance in a Straight Table

Anonymous — Wed, 24 Dec 2014 17:00:43 GMT

Hello,

you can use this expression:

pow(RangeStdev(Column(1), Column(2)),2)

and so on for others columns.

To colour it, you can use Backgorund colour editing if(Var>=0 green(), red()) where Var is the name of expression.

KR,

Elena

Re: How to write Expression for Variance in a Straight Table

anbu1984 — Wed, 24 Dec 2014 17:18:49 GMT

Check this app

Re: How to write Expression for Variance in a Straight Table

Anonymous — Wed, 24 Dec 2014 17:26:45 GMT

Thank you Anbu for the APP but my personal edition does not allow me to open any qvw files except created from my PC. Can you post the script or a snap shot

Re: How to write Expression for Variance in a Straight Table

anbu1984 — Wed, 24 Dec 2014 17:36:12 GMT

Expressions:

Sum({<Year={2011}>}Sales)

Sum({<Year={2012}>}Sales)

Sum({<Year={2013}>}Sales)

(Column(2) - Column(1))/Column(2) --Background color expr: If(Column(4) > 0,Green(),Red())

(Column(3) - Column(2))/Column(3) --Background color expr: If(Column(5) > 0,Green(),Red())

Re: How to write Expression for Variance in a Straight Table

Anonymous — Wed, 24 Dec 2014 17:37:29 GMT

Elena,

the variance after using your syntax (I copied and pasted in the new expression) is way more. I have attached the result here. May be the expn needs modification..

Re: How to write Expression for Variance in a Straight Table

Anonymous — Wed, 24 Dec 2014 18:09:31 GMT

Thats perfect, Thank you @anbu. Happy Holidays.

Re: How to write Expression for Variance in a Straight Table

anbu1984 — Wed, 24 Dec 2014 18:11:47 GMT

Please close the thread, if your queries are answered

Re: How to write Expression for Variance in a Straight Table

Anonymous — Wed, 24 Dec 2014 18:34:42 GMT

Sure Anbu, I will do that. Thanks again.

Regards,