Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator II
Creator II

IF or apply map

Hi

 

I have two tables 

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

 

 

 

1 Solution

Accepted Solutions
Nicole-Smith

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.

View solution in original post

3 Replies
Nicole-Smith

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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