topic Re: Re: Calculate Profit for last 4 consecutive Quarters in QlikView https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621573#M228822 <HTML><HEAD></HEAD><BODY><P>Dear Ravi,</P><P></P><P>PFA the application.</P><P></P><P>I want to just count and show the no. of dealers who have consecutively scored profit in last 4 quarters.</P><P></P><P>Regars,</P></BODY></HTML> Thu, 10 Apr 2014 06:57:05 GMT 2014-04-10T06:57:05Z Calculate Profit for last 4 consecutive Quarters https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621570#M228819 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have dealers data consisting of expenditure &amp; earnings.</P><P>Absorption ratio is Earnings divided by Expenditure, if it is greater than 1 - dealers are in profit else loss.</P><P></P><P>Now I want to find out how many dealers are profitable for last 4 consecutive quarters and its % against total dealers.</P><P></P><P>Please help.</P><P></P><P>Regards,</P></BODY></HTML> Thu, 10 Apr 2014 05:02:05 GMT https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621570#M228819 2014-04-10T05:02:05Z Re: Calculate Profit for last 4 consecutive Quarters https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621571#M228820 <HTML><HEAD></HEAD><BODY><P>May this helps you</P><P><A href="http://www.qlikfix.com/2010/11/10/visualizing-customer-profitability-with-a-whale-curve/" title="http://www.qlikfix.com/2010/11/10/visualizing-customer-profitability-with-a-whale-curve/">http://www.qlikfix.com/2010/11/10/visualizing-customer-profitability-with-a-whale-curve/</A></P><P></P><P></P><P>Vikas</P></BODY></HTML> Thu, 10 Apr 2014 05:19:05 GMT https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621571#M228820 vikasmahajan 2014-04-10T05:19:05Z Re: Calculate Profit for last 4 consecutive Quarters https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621572#M228821 <HTML><HEAD></HEAD><BODY><P>Can you post your sample data or app ?</P><P><BR /> </P></BODY></HTML> Thu, 10 Apr 2014 05:40:56 GMT https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621572#M228821 2014-04-10T05:40:56Z Re: Re: Calculate Profit for last 4 consecutive Quarters https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621573#M228822 <HTML><HEAD></HEAD><BODY><P>Dear Ravi,</P><P></P><P>PFA the application.</P><P></P><P>I want to just count and show the no. of dealers who have consecutively scored profit in last 4 quarters.</P><P></P><P>Regars,</P></BODY></HTML> Thu, 10 Apr 2014 06:57:05 GMT https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621573#M228822 2014-04-10T06:57:05Z Re: Calculate Profit for last 4 consecutive Quarters https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621574#M228823 <HTML><HEAD></HEAD><BODY><P>Thanks Vikas for the link.</P><P>But unfortunately it can't help me.</P></BODY></HTML> Mon, 14 Apr 2014 05:10:00 GMT https://community.qlik.com/t5/QlikView/Calculate-Profit-for-last-4-consecutive-Quarters/m-p/621574#M228823 2014-04-14T05:10:00Z