topic Re: Find the highest of two values and replace them. in App Development https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425729#M34007 <HTML><HEAD></HEAD><BODY><P>This is how it can be done in a load script:</P><P></P><P><IMG alt="2017-12-06 21_30_06-Qlik Sense Desktop.png" class="jive-image image-1" src="/legacyfs/online/185986_2017-12-06 21_30_06-Qlik Sense Desktop.png" style="height: auto;" /></P><P></P><P>and lines from 20 to 29 can of course be replaced with a LOAD ... FROM or LOAD ...; SQL SELECT ...</P></BODY></HTML> Wed, 06 Dec 2017 20:32:15 GMT petter 2017-12-06T20:32:15Z Find the highest of two values and replace them. https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425726#M34004 <HTML><HEAD></HEAD><BODY><P>Hi, i'm looking to compare the ClusterNameFinal and replace the Compliance Score Final that has the lower score with the highest score that has the same ClusterNameFinal.</P><P><IMG alt="QlikQuestion.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/185695_QlikQuestion.PNG" style="height: 82px; width: 620px;" /></P><P></P><P>So the end result would look something like this:</P><P><IMG alt="QlikQuestion.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/185708_QlikQuestion.PNG" style="height: 91px; width: 620px;" /></P></BODY></HTML> Tue, 05 Dec 2017 08:17:44 GMT https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425726#M34004 Anonymous 2017-12-05T08:17:44Z Re: Find the highest of two values and replace them. https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425727#M34005 <HTML><HEAD></HEAD><BODY><P>In it's simplest form you can use this expression as a Measure:</P><P></P><P>Max(TOTAL &lt;ClusterNameFinal&gt;&nbsp; [Compliance Score Final])</P><P></P><P><IMG alt="2017-12-05 19_26_47-Qlik Sense Desktop.png" class="jive-image image-1" src="/legacyfs/online/185809_2017-12-05 19_26_47-Qlik Sense Desktop.png" style="height: 378px; width: 620px;" /></P><P></P><P>The assumption is that the combination of HostNameFinal and ClusterNameFinal only have a single row of data.</P></BODY></HTML> Tue, 05 Dec 2017 18:30:44 GMT https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425727#M34005 petter 2017-12-05T18:30:44Z Re: Find the highest of two values and replace them. https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425728#M34006 <HTML><HEAD></HEAD><BODY><P>‌hi, thanks for suggesting a solution, but how can this be done in the data load editor instead?</P></BODY></HTML> Wed, 06 Dec 2017 00:00:48 GMT https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425728#M34006 Anonymous 2017-12-06T00:00:48Z Re: Find the highest of two values and replace them. https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425729#M34007 <HTML><HEAD></HEAD><BODY><P>This is how it can be done in a load script:</P><P></P><P><IMG alt="2017-12-06 21_30_06-Qlik Sense Desktop.png" class="jive-image image-1" src="/legacyfs/online/185986_2017-12-06 21_30_06-Qlik Sense Desktop.png" style="height: auto;" /></P><P></P><P>and lines from 20 to 29 can of course be replaced with a LOAD ... FROM or LOAD ...; SQL SELECT ...</P></BODY></HTML> Wed, 06 Dec 2017 20:32:15 GMT https://community.qlik.com/t5/App-Development/Find-the-highest-of-two-values-and-replace-them/m-p/1425729#M34007 petter 2017-12-06T20:32:15Z