Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Find the highest of two values and replace them.

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.

QlikQuestion.PNG

So the end result would look something like this:

QlikQuestion.PNG

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

This is how it can be done in a load script:

2017-12-06 21_30_06-Qlik Sense Desktop.png

and lines from 20 to 29 can of course be replaced with a LOAD ... FROM or LOAD ...; SQL SELECT ...

View solution in original post

3 Replies
petter
Partner - Champion III
Partner - Champion III

In it's simplest form you can use this expression as a Measure:

Max(TOTAL <ClusterNameFinal>  [Compliance Score Final])

2017-12-05 19_26_47-Qlik Sense Desktop.png

The assumption is that the combination of HostNameFinal and ClusterNameFinal only have a single row of data.

Anonymous
Not applicable
Author

‌hi, thanks for suggesting a solution, but how can this be done in the data load editor instead?

petter
Partner - Champion III
Partner - Champion III

This is how it can be done in a load script:

2017-12-06 21_30_06-Qlik Sense Desktop.png

and lines from 20 to 29 can of course be replaced with a LOAD ... FROM or LOAD ...; SQL SELECT ...