Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
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.

Regards,

4 Replies
vikasmahajan

Not applicable
Author

Can you post your sample data or app ?


Not applicable
Author

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,

Not applicable
Author

Thanks Vikas for the link.

But unfortunately it can't help me.