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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-01-30 08:45 AM

Max function doubt

Hi

I have a code which gives the name of the metric corresponding to the max value change among 20 metrics.

The code is:

=MaxString({<MTA_Change={'$(=max(MTA_Change,1))'}>}Metric)

The problem I'm facing is that if there are two metrics with the same MTA_change then the code is not working. I want the 1st metric to be shown when the rank is 1 and the second metric when the rank is 2.

Can anybody help on this?

194 Views
0 Likes
0 Replies