Discussion board where members can get started with Qlik Sense.
I am having trouble removing the duplicates from my load. I know I am able to remove duplicates by using the distinct load, but that doesn't allow me to pick wich values are the ones that stay.
Go to Solution.
one technique might be to calculate the value field you are interested in, and JOIN this back on to your original table. For example:
[wherever your original source is];
INNER JOIN (OriginalTable)
max(value) as value
GROUP BY key;