Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mahendragaur
Creator
Creator

Value next to Max Value in Column

Hello All,

I want to get the Value from next column to max value of any column. fox example max value is "663457" in column 'A' and it's row no. is "136". So,  I want value from column 'B' of row no. '136'

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

=FirstSortedValue(Name, -Value)                         // note '-' sign

View solution in original post

6 Replies
tresesco
MVP
MVP

Try using FirstSortedValue()

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Upload the sample data.
mahendragaur
Creator
Creator
Author

I don't want to get the value from the same column. I want value from neighbor column if max value is found in column A.

for example- max value is "663457" in column 'A' and it's row no. is "136". So, I want value from column 'B' of row no. '136'
tresesco
MVP
MVP

Did you try the function - firstsortedvalue(), I suggested above? If using the same function, you can't get the result, try to share a sample app to get more specific help.
mahendragaur
Creator
Creator
Author

Below is the table I have. I need to show the Name 'c' in a variable because it has the max Value i.e. '6'

Name Value
a 3
b 5
c 6
d 1
tresesco
MVP
MVP

=FirstSortedValue(Name, -Value)                         // note '-' sign