QlikSense how to find closest date from one field to another

[qwebnm]

hello.

Qliksense I would like to know how to find the closest date from one field to another.
I have fields close data, data.
I want to show the date value closest to data in close data.
I don't know what to do.
What should I do?

Please help if possible.
thank you

[henrikalmen]

Remove the column "close date", then you will have only one row. Your problem is that the column "close date" has more than one value, and therefore you get one row for each of those values.

If you don't want to remove that column, you need to somehow make sure that it has only one value for each row that should be unique.