Non matching records in lookup function should return as Zero instead of '-'

bharani8 — Thu, 23 Jun 2016 06:38:48 GMT

Hello Experts - I believe it will be simple for you... I have performed an lookup function and for the non-matching records(records which is available in one table but not in other table) i like to get the number as Zero instead of "-" symbol.. Please Help!!

Re: Non matching records in lookup function should return as Zero instead of '-'

marcus_sommer — Thu, 23 Jun 2016 11:22:30 GMT

Lookup provides no alternative value by a non-matching of the values. Therefore you need to wrap the lookup with alt(lookup(), 0) or rangesum(lookup()) when the values are numeric and by string-values you could use an if(len(lookup())>0, lookup(), 'some other value').

An alternatively to a lookup might be a mapping with applymap: Mapping … and not the geographical kind.

- Marcus

topic Re: Non matching records in lookup function should return as Zero instead of '-' in QlikView

Non matching records in lookup function should return as Zero instead of '-'

Re: Non matching records in lookup function should return as Zero instead of '-'