Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Margin Calculation

hello

I wish to calculate top 5 worst margin with highest revenue per AccountName, suggest any method to calculate

Thanks In Advance

2 Replies
tresesco
MVP
MVP

Rank() with negative indicator would help you get worst. Try to share a qvw with sample data.

amit_saini
Master III
Master III

Hi ,

Rank function will help you here.