topic Re: Field selection using two criteria: one simple and one complex in QlikView

Field selection using two criteria: one simple and one complex

MarcosSanz — Sat, 16 Nov 2024 04:13:38 GMT

I have a table with year, people ID, and a column that says if he/she is retired or not.

People retired is acumulated every year. So at 2020, the table shows people retired during 2018, 2019 and 2020.

I want to show, per year, only the ID of new people retired, excluding people retired during previous years. I attach an excel sheet with the original table, the filter I need an the final answer desired.

Thanks.

Re: Field selection using two criteria: one simple and one complex

MarcoWedel — Sun, 10 Mar 2019 13:10:47 GMT

Derive the retired year as separate field in the script and use this year as dimension

Re: Field selection using two criteria: one simple and one complex

MarcoWedel — Sun, 10 Mar 2019 13:15:48 GMT

e. g. like

Left Join (tabPeople)
LOAD ID_persona,
Min(Year) as RetiredYear
Resident tabPeople
Where Retired = 'Yes'
Group By ID_persona ;

Re: Field selection using two criteria: one simple and one complex

NZFei — Mon, 11 Mar 2019 00:20:49 GMT

Dim1: Year

Dim2: ID_persona

Expression:

if(Year=min({<Retired={"Yes"}>}total <ID_persona> Year),
'Yes'
)

Re: Field selection using two criteria: one simple and one complex

MarcosSanz — Mon, 11 Mar 2019 09:54:14 GMT

Thank you very much. It works!

Now I have to understand better how 🙂