Set Analysis Query

[#1]

Hi

Hopefully I'm clear in explaining this complex problem.

I have a grid with some data and some filters at the top.

On button's action, it filters the data by dates. Here I would like to add another expression to pick the latest record (latest age of break) within the filtered data. Same unique ids, but latest age of break.

For e.g GGLXXXX54888EUR2889050110EUR_135695 has two records. When clicked on the button it will filter by dates and I would then like to pick the latest one (age of break = 2) from the filter.

Please look at the attached qvw.

Thanks for your help.

[tresesco]

Is this what you want?

PFA.

[#3]

Thanks.

Although that will give me latest ir-respective of unique Ids. If I clear all and just get latest age, it will be ignore all unique Ids and find the latest age.

I'd like latest age for each unique Id.

[Kushal_Chawda]

No need to create button for max of Age

See the attached one

[tresesco]

this?

PFA