topic Re: Value next to Max Value in Column in QlikView

Value next to Max Value in Column

mahendragaur — Sat, 16 Nov 2024 04:23:39 GMT

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'

Re: Value next to Max Value in Column

tresB — Wed, 20 Feb 2019 10:19:19 GMT

Try using FirstSortedValue()

Re: Value next to Max Value in Column

MindaugasBacius — Wed, 20 Feb 2019 14:17:11 GMT

Upload the sample data.

Re: Value next to Max Value in Column

mahendragaur — Thu, 21 Feb 2019 05:09:45 GMT

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'

Re: Value next to Max Value in Column

tresB — Thu, 21 Feb 2019 06:31:07 GMT

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.

Re: Value next to Max Value in Column

mahendragaur — Thu, 21 Feb 2019 06:36:03 GMT

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

Re: Value next to Max Value in Column

tresB — Thu, 21 Feb 2019 06:41:16 GMT

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