Calculate Profit for last 4 consecutive Quarters - Qlik Community

Report Inappropriate Content · ‎2014-04-10

Dear All,

I have dealers data consisting of expenditure & earnings.

Absorption ratio is Earnings divided by Expenditure, if it is greater than 1 - dealers are in profit else loss.

Now I want to find out how many dealers are profitable for last 4 consecutive quarters and its % against total dealers.

Please help.

Regards,

vikasmahajan · ‎2014-04-10

May this helps you

http://www.qlikfix.com/2010/11/10/visualizing-customer-profitability-with-a-whale-curve/

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2014-04-10

Can you post your sample data or app ?

Report Inappropriate Content · ‎2014-04-10

Dear Ravi,

PFA the application.

I want to just count and show the no. of dealers who have consecutively scored profit in last 4 quarters.

Regars,

Report Inappropriate Content · ‎2014-04-14

Thanks Vikas for the link.

But unfortunately it can't help me.