Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate Profit for last 4 consecutive Quarters

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.


4 Replies

Not applicable

Can you post your sample data or app ?

Not applicable

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.


Not applicable

Thanks Vikas for the link.

But unfortunately it can't help me.