Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
pgalvezt
Valued Contributor

Handle mapping with nulls

Hello,

I have a resident table with 2 conditions: a and b. I would like to bring F3 and F4 through Mapping. When cod is null

Bring F3 and F4 by Name... If cod is not null bring F3 and F4 by cod. The idea is always bring F3 and F4 by cod or

Name depending is the cod has data or use the Name when the cod be null.  Sometimes b has the same cod one of them has data and the other line has F3 and F4 with null values. so I need to bring the line with data. 

F1      Cod Name     F3   F4

a        1     cod1        ab  tg 

b        2     cod2         bc  rf

a               cod3        ab  ed      

b        4     cod4                     Here there isn't data in F3 and F4

b        4     cod4        tb  yh    so I need to bring this line.

Thanks!

1 Solution

Accepted Solutions
Highlighted
pgalvezt
Valued Contributor

Re: Handle mapping with nulls

3 Replies
Highlighted
MVP
MVP

Re: Handle mapping with nulls

Where did tb and yh come from? I suggest that your provide more information such as the relevant mappings and the load script that applies the mapping as well as a more comprehensive set of examples.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
rupamjyotidas
Valued Contributor

Re: Handle mapping with nulls

An example app will be useful but you can always define a value for NULL in apply map function

applymap('map1', 5, null( ) )  or

applymap ('map1', 5, 'XYZ' )

Highlighted
pgalvezt
Valued Contributor

Re: Handle mapping with nulls