topic Re: Lookup default value in QlikView

Lookup default value

rdsuperlike — Wed, 21 Jan 2015 01:24:50 GMT

How to set a default in lookup. I want to default my value of Grossdata = 1 if there is no match.

Lookup('dpw','key',NAME &'-' & VENDOR &'-' & Year(DATE) &'-' & Month(DATE) ,'Grossdata')

Any help is appreciated.

Re: Lookup default value

lucianoginqo — Wed, 21 Jan 2015 02:13:10 GMT

did you try

if(isnull(Lookup('dpw','key',NAME &'-' & VENDOR &'-' & Year(DATE) &'-' & Month(DATE) ,'Grossdata')),1,Lookup('dpw','key',NAME &'-' & VENDOR &'-' & Year(DATE) &'-' & Month(DATE) ,'Grossdata'))

This might not be the most efficient way but it should accomplish what you need?

Re: Lookup default value

anbu1984 — Wed, 21 Jan 2015 02:22:09 GMT

Tbl:

LOAD * Inline [

Key,Value

1,aaa

2,bbb ];

Load *,If(IsNull(Lookup('Value','Key',Key,'Tbl')),'Default',Lookup('Value','Key',Key,'Tbl')) Inline [

Key

3 ];

Re: Lookup default value

Wed, 21 Jan 2015 13:13:42 GMT

Hi!

Is result numeric? Then what about "RangeSum" or "Alt"?

Alt(

Lookup('dpw','key',NAME &'-' & VENDOR &'-' & Year(DATE) &'-' & Month(DATE) ,'Grossdata')

, 1)