Qlik Community

Qlik Sense App Development

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

Highlighted
Partner
Partner

Applymap for Null values after Qlik join

stalwar1johnwcri

Hello to the above and anyone that can help!

I am trying to map null orphan values to a default value of 0 after an outer join has occurred. Is this possible?

Here is the code:

[Tracker]:

LOAD

    "MIA CASE SEQ" as [MIA CASE SEQ-MIA_CASE_SEQ],

    MT,

    Y,

    AU,

  

FROM mysource

[Other table]:

Load

"MIA_CASE_SEQ" as [MIA CASE SEQ-MIA_CASE_SEQ],

FIELD1

FIELD2

FIELD3

From qvd.source

**Now, how do I go about applying a map to this outerjoined table?  I need to make sure that all the in all the instances that there was not a join on the [MIA CASE SEQ-MIA_CASE_SEQ] that the corresponding orphan nulls for AU, MT, and Y = 0. **


Any thoughts/comments would be much appreciated.


Thanks,

Ben

1 Solution

Accepted Solutions
MVP
MVP

Re: Applymap for Null values after Qlik join

You can do it with another resident load and this mapping approach showed in

Filling Default Values Using Mapping | Qlikview Cookbook

3 Replies
MVP & Luminary
MVP & Luminary

Re: Applymap for Null values after Qlik join

MVP
MVP

Re: Applymap for Null values after Qlik join

You can do it with another resident load and this mapping approach showed in

Filling Default Values Using Mapping | Qlikview Cookbook

Partner
Partner

Re: Applymap for Null values after Qlik join

Stefan,

Perfect! I had seen that solution mentioned in another post but it did not have the resident load statement included.

Thanks,

Ben