Discussion Board for collaboration related to QlikView App Development.
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.
May this helps you
Can you post your sample data or app ?
PFA the application.
I want to just count and show the no. of dealers who have consecutively scored profit in last 4 quarters.
Thanks Vikas for the link.
But unfortunately it can't help me.