topic How to create comparison between neighboring data on graph? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-comparison-between-neighboring-data-on-graph/m-p/1302466#M460842 <HTML><HEAD></HEAD><BODY><P><IMG /></P><P>Hi!</P><P></P><P>I have trouble, which bother me for long time. I want compare two neighboring data on graph, which show sum of sale in given periods. I am using formula (sum of sale is my variable) =<STRONG>sum(sum of sale) / above(sum(sum of sale),rowno()-1), </STRONG>which works, but no in way I want - it compare every data to first value, not to nieghboring. I want to have different effect - the second value to first, the third to second etc. And it must be universal, because i want to filter months, according to my needs in some point of analysis. Can you help me? I'll be grateful. </P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158112_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 29 Mar 2017 13:59:26 GMT 2017-03-29T13:59:26Z How to create comparison between neighboring data on graph? https://community.qlik.com/t5/QlikView/How-to-create-comparison-between-neighboring-data-on-graph/m-p/1302466#M460842 <HTML><HEAD></HEAD><BODY><P><IMG /></P><P>Hi!</P><P></P><P>I have trouble, which bother me for long time. I want compare two neighboring data on graph, which show sum of sale in given periods. I am using formula (sum of sale is my variable) =<STRONG>sum(sum of sale) / above(sum(sum of sale),rowno()-1), </STRONG>which works, but no in way I want - it compare every data to first value, not to nieghboring. I want to have different effect - the second value to first, the third to second etc. And it must be universal, because i want to filter months, according to my needs in some point of analysis. Can you help me? I'll be grateful. </P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158112_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 29 Mar 2017 13:59:26 GMT https://community.qlik.com/t5/QlikView/How-to-create-comparison-between-neighboring-data-on-graph/m-p/1302466#M460842 2017-03-29T13:59:26Z Re: How to create comparison between neighboring data on graph? https://community.qlik.com/t5/QlikView/How-to-create-comparison-between-neighboring-data-on-graph/m-p/1302467#M460843 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(sum of sale)/Above(Sum(sum of sale))</STRONG></P></BODY></HTML> Wed, 29 Mar 2017 15:07:38 GMT https://community.qlik.com/t5/QlikView/How-to-create-comparison-between-neighboring-data-on-graph/m-p/1302467#M460843 sunny_talwar 2017-03-29T15:07:38Z Re: How to create comparison between neighboring data on graph? https://community.qlik.com/t5/QlikView/How-to-create-comparison-between-neighboring-data-on-graph/m-p/1302468#M460844 <HTML><HEAD></HEAD><BODY><P>Yeah, of course, it works! Actually I've just overcomplicated it with this rowno. I think i did it because I want to have 100% on the first data, but to be honest it's not so important, so with your formula everything works smooth and I'm happy with this solution.</P><P></P><P></P><P>Thanks Sunny!</P></BODY></HTML> Thu, 30 Mar 2017 08:01:14 GMT https://community.qlik.com/t5/QlikView/How-to-create-comparison-between-neighboring-data-on-graph/m-p/1302468#M460844 2017-03-30T08:01:14Z