IF or apply map

[New-Qlik]

Hi

I have two tables 

Customer and Occupation which have 1 to many relation. I want to show output as final front end table..

[Nicole-Smith · Accepted solution]

The following should work:

Dimension 1: ID
Dimension 2: Name

Measure: MaxString(if(Year=year(today()), Type))

I'm using the MaxString() because Only() will show a null if there is more than one value.  The if() statement is needed instead of using set analysis because you still want to show the blanks.

[New-Qlik]

Thanks Nicole.
I tried it gives me two rows for.
ID Name TYpe
1 John PL
1 John
2 OLA
3 Rick
4 Neha TL
4 Neha

[New-Qlik]

Its working fine, I have one more filter applier that why it was not working earlier. Thanks