topic Re: Expression issue in QlikView https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413881#M568116 <HTML><HEAD></HEAD><BODY><P>You mean it differs for every year?</P></BODY></HTML> Wed, 07 Nov 2012 21:21:36 GMT CELAMBARASAN 2012-11-07T21:21:36Z Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413878#M568113 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a plot-chart with 2 dimensions :&nbsp;&nbsp; MONTH&nbsp; ,&nbsp; YEAR</P><P>and one expression&nbsp; :&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(&nbsp;&nbsp; Value)&nbsp; </P><P></P><P>My objective is to change the expression to transform it in an index as </P><P>Sum( Value) /&nbsp; Sum(&nbsp; the value of first month)&nbsp; </P><P></P><P>How to write the denominator taking account the first month for each years in my expressions</P><P></P><P>Thanks for your help</P><P></P><P>JJ</P></BODY></HTML> Wed, 07 Nov 2012 21:08:17 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413878#M568113 2012-11-07T21:08:17Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413879#M568114 <HTML><HEAD></HEAD><BODY><P>Try something like</P><P>Sum(Value)/Sum(TOTAL &lt;YEAR&gt; {&lt;Month={'Jan'}&gt;} Value)</P></BODY></HTML> Wed, 07 Nov 2012 21:11:01 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413879#M568114 CELAMBARASAN 2012-11-07T21:11:01Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413880#M568115 <HTML><HEAD></HEAD><BODY><P>Thanks Cel</P><P></P><P>What about if my first month is not Jan ? </P><P></P><P>JJ</P></BODY></HTML> Wed, 07 Nov 2012 21:17:20 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413880#M568115 2012-11-07T21:17:20Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413881#M568116 <HTML><HEAD></HEAD><BODY><P>You mean it differs for every year?</P></BODY></HTML> Wed, 07 Nov 2012 21:21:36 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413881#M568116 CELAMBARASAN 2012-11-07T21:21:36Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413882#M568117 <HTML><HEAD></HEAD><BODY><P>Yep! Thanks for tour effort </P></BODY></HTML> Wed, 07 Nov 2012 21:37:59 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413882#M568117 2012-11-07T21:37:59Z Re: Expression issue https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413883#M568118 <HTML><HEAD></HEAD><BODY><P>Have you tried already with the chart inter record functions, namely top()?</P></BODY></HTML> Wed, 07 Nov 2012 21:39:25 GMT https://community.qlik.com/t5/QlikView/Expression-issue/m-p/413883#M568118 swuehl 2012-11-07T21:39:25Z