Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mahendragaur
Contributor

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
MVP
MVP

Re: Value next to Max Value in Column

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

6 Replies
MVP
MVP

Re: Value next to Max Value in Column

Try using FirstSortedValue()

MindaugasBacius
Valued Contributor III

Re: Value next to Max Value in Column

Upload the sample data.
mahendragaur
Contributor

Re: Value next to Max Value in Column

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'
MVP
MVP

Re: Value next to Max Value in Column

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
Contributor

Re: Value next to Max Value in Column

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
MVP
MVP

Re: Value next to Max Value in Column

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