Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
avneet85
Contributor 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

Re: IF or apply map

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

Re: IF or apply map

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

avneet85
Contributor II

Re: IF or apply map

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
avneet85
Contributor II

Re: IF or apply map

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