Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
muniyandi
Creator III
Creator III

How to get string column value based on two column Max of value (Expression)


Hi Team,

i want to get Mac_Code column  value based on max of value of two column (VAL1,VAL2) in Text box expression.

Condition: first we have to consider VAL1 column Max of value then VAL2 column max of value.

Expecting Result is Mac_Code Value = E.

i have tried using FirstSortedOrder function some case max of value in VAL1 column repeated the same value ,this case i'm getting NULL.

Sample Data:

                     

Mac_CodeVAL1VAL2
A794300
B454800
C1003800
D99.914000
E1004100
F895000
G99.12300
H971020
I1003950
J95.342500
K1002700
1 Reply
muniyandi
Creator III
Creator III
Author

any updates guys...