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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
2 Replies
tresB
Champion III
Champion III

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.