Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Highlighted
MVP
MVP

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

Filling Default Values Using Mapping | Qlikview Cookbook

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Highlighted
MVP
MVP

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

Filling Default Values Using Mapping | Qlikview Cookbook

View solution in original post

Highlighted
Partner
Partner

Stefan,

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

Thanks,

Ben