Discussion board where members can get started with Qlik Sense.
Is there a way to compare between certain fields values within a row (On Script)?
I have 5 fields, and want to insert the maximum between them to a new column.
Max function not relevant for this type of case.
Is there a way to do that?
Thanks in advance
The function RangeMax and RangeMin should be helpful. They can take a variable number of parameters and get the Min/Max and they work both in script and in charts:
Should be like this in your case:
RangeMax( Field1 , Field2 , Field3 , Field4 , Field5 )
View solution in original post
if(F1>F2 and F1>F3 and F1>F4 and F1>F5, F1,
if(F2>F3 and F2>F4 and F2>F5, F2,
if(F3>F4 and F3>F5, F3,
if(F4>F5, F4, F5))))