topic Re: IF or apply map in App Development

IF or apply map

New-Qlik — Mon, 01 Apr 2019 20:18:36 GMT

I have two tables

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

Re: IF or apply map

Nicole-Smith — Mon, 01 Apr 2019 21:00:12 GMT

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.

Re: IF or apply map

New-Qlik — Mon, 01 Apr 2019 21:14:44 GMT

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

Re: IF or apply map

New-Qlik — Mon, 01 Apr 2019 21:27:10 GMT

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