topic Any function can get the 'exist' result? in QlikView

Any function can get the 'exist' result?

Tue, 08 Mar 2011 05:40:31 GMT

Hi,

I have a varible named v_year and a table like:

Year

2008

2007

2001

I want to get a function which can return a ture-or-false value:

TURE : if $(v_year) exist in field [Year]

FALSE: if $(v_year) not exist in field [Year]

How can I write the expression? Any function can do that? I want to use the expression as a condition in if clause.

tresB — Tue, 08 Mar 2011 06:02:58 GMT

if you are trying in the script, you can create flag like this:

LOAD Year,

If(Year='$(v_year)',1,0) as MatchFlag From ....

otherwise there is a function called EXISTS().... you can have a look at it.

Regards, tresesco.

pover — Tue, 08 Mar 2011 06:04:55 GMT

Here's one option:

=if(only({$<Year={$(vYear)}>} Year),'Exists','Does not Exist')

Regards.

Tue, 08 Mar 2011 08:10:29 GMT

Hi,

The condition is not work. May be NOT(ISNULL(ONLY(....))) is ok.