topic Re: Calculating growth in QlikView https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600223#M478772 <HTML><HEAD></HEAD><BODY><P>Thanks,but, can you share just formula</P></BODY></HTML> Wed, 05 Mar 2014 06:59:41 GMT vijetas42 2014-03-05T06:59:41Z Calculating growth https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600220#M478769 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How should I calculate growth using month data for current and previous like,for example,for feb it should calculate feb-jan likewise show data for all 12 months?</P></BODY></HTML> Wed, 05 Mar 2014 05:38:07 GMT https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600220#M478769 vijetas42 2014-03-05T05:38:07Z Re: Calculating growth https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600221#M478770 <HTML><HEAD></HEAD><BODY><P>PFA for sample app.</P></BODY></HTML> Wed, 05 Mar 2014 05:52:32 GMT https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600221#M478770 tresB 2014-03-05T05:52:32Z Re: Calculating growth https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600222#M478771 <HTML><HEAD></HEAD><BODY><P>hi </P><P>You will have to use Above Function:</P><P>Try</P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">RangeSum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Sales</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">),-</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">above</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Sales</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)))/</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">above</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">sum</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">Sales</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">))</SPAN></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Himank<BR /></SPAN></P></BODY></HTML> Wed, 05 Mar 2014 06:53:27 GMT https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600222#M478771 2014-03-05T06:53:27Z Re: Calculating growth https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600223#M478772 <HTML><HEAD></HEAD><BODY><P>Thanks,but, can you share just formula</P></BODY></HTML> Wed, 05 Mar 2014 06:59:41 GMT https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600223#M478772 vijetas42 2014-03-05T06:59:41Z Re: Calculating growth https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600224#M478773 <HTML><HEAD></HEAD><BODY><P>Thanks,but this formula is not working with my scenario</P></BODY></HTML> Wed, 05 Mar 2014 07:00:13 GMT https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600224#M478773 vijetas42 2014-03-05T07:00:13Z Re: Calculating growth https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600225#M478774 <HTML><HEAD></HEAD><BODY><P>How this formula works sum( aggr( rangesum( above( sum([IN CRORE]),2,1) ),[FS Month]))?</P></BODY></HTML> Wed, 05 Mar 2014 07:18:16 GMT https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600225#M478774 vijetas42 2014-03-05T07:18:16Z Re: Calculating growth https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600226#M478775 <HTML><HEAD></HEAD><BODY><P><BR />Dimension: Month</P><P>Expression: Sum(Data)-Above(Sum(Data)))/Above(Sum(Data)</P><P>Number Format: 'Show in Percent(%)'</P></BODY></HTML> Wed, 05 Mar 2014 07:22:27 GMT https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600226#M478775 tresB 2014-03-05T07:22:27Z Re: Calculating growth https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600227#M478776 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>You will have to use Above Function.</P><P>Can You attach a Sample File?</P></BODY></HTML> Wed, 05 Mar 2014 08:47:25 GMT https://community.qlik.com/t5/QlikView/Calculating-growth/m-p/600227#M478776 2014-03-05T08:47:25Z