Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
alina_qlik
Contributor III
Contributor III

How to find average revenue loss ?

Fellas / Mentors ,

I need to find average loss and gain in revenue for every one spot increase / decrease in Ranking by
a) Overall 
b) Firm and Year

Trend_data:

AssetRevenueRankQUARTERYEARFirmRevenue_ChangeRank_Change
30008Q12018Lawson00
200010Q22018Lawson-1000-2
100004Q32018Lawson80006
70006Q42018Lawson-3000-2
200012Q12019Ericson-5000-6
200011Q22019Ericson01
50005Q32019Ericson-30006
100012Q42019Ericson-4000-7

 

Output should tell me something like this :
For every dip in rank by one spot , xxxx amount of revenue is lost 

Thank ya

 

3 Replies
Taoufiq_Zarra

@alina_qlik  can you share the expected output from this sample ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
alina_qlik
Contributor III
Contributor III
Author

Thanks Taoifiq for respone .

Lehme narrate again 

for Lawson in q1 2018 revenue was 3000 and rank was 8 and in q2 ranked changed to 10 , i.e dip by 2 spot along with revenue which took dip from 3000 to 2000 . 
Hence for rank dip by 2 spot revenue dipped by 1000 - so we can mathematematically say that the average dip in revenue is 500 for every single dip in rank over first two quarter of '18 .

Now applying similar logic , wanna find average dip in revenue for every dip in rank by one spot when looking at over all data .

alina_qlik
Contributor III
Contributor III
Author

Being not great at school mathematics , i am not sure if that can be calculated 

using

 average dip in revenue for every dip in rank by one spot  =  sum(Revenue_Change)/sum( Rank_Change)