topic Re: Applymap for Null values after Qlik join in App Development

Applymap for Null values after Qlik join

benwashburne — Wed, 05 Sep 2018 00:08:36 GMT

stalwar1‌ johnw‌ cri‌

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,

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

Re: Applymap for Null values after Qlik join

marcus_sommer — Wed, 05 Sep 2018 07:20:46 GMT

See: Re: Orphan Records in Qliksense

- Marcus

Re: Applymap for Null values after Qlik join

swuehl — Wed, 05 Sep 2018 07:48:23 GMT

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

Filling Default Values Using Mapping | Qlikview Cookbook

Re: Applymap for Null values after Qlik join

benwashburne — Wed, 05 Sep 2018 23:13:12 GMT

Stefan,

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

Thanks,

Ben