topic IF In List Statement in QlikView

IF In List Statement

ivandrago — Fri, 28 Jan 2011 16:41:30 GMT

Hi,

I want to add a flag and set this to 1 if the name is equal to Trev or Ross, I have tried the following script but QlikVIew does not like it?

If(Name in ('Trev','Ross'),1,0) as Flag

Thanks

Ivan

IF In List Statement

hector — Fri, 28 Jan 2011 16:43:53 GMT

Hi, use match instead

If(match(Name,'Trev','Ross'),1,0) as Flag

Rgds

IF In List Statement

ivandrago — Fri, 28 Jan 2011 16:59:37 GMT

Nice Work Hector

Re: IF In List Statement

Shax — Mon, 04 Jul 2022 16:08:13 GMT

how to write multiple names in "Name"?

Re: IF In List Statement

sidhiq91 — Tue, 05 Jul 2022 06:01:21 GMT

@Shax how many names are we talking about? If it is way too high, we can get the desired output using Mapping Load and Applymap concept. Something like below:

Mappingtable:

Mapping load

Name

Value

From Table_Name:

MainTable:

Load Name,

Applymap('Mappingtable',Name,'Unknown') as Flag

From Table_Name;

Re: IF In List Statement

marcus_sommer — Tue, 05 Jul 2022 06:05:12 GMT

You may try:

If(wildmatch(Name1 & '|' & Name2,'*Trev*','*Ross*'),1,0) as Flag

But you will need to specify all relevant name-fields directly and also using wildmatch() by applying wildcards to your search-strings which may result in some overlapping.

Alternatives could be to nest multiple match() logic or to transform your crosstable-structures with a crosstable-statement into a stream-data-structure - means it remains only one name-field and the multiple values are distributed to records.

- Marcus

Re: IF In List Statement

Nakosan — Sun, 20 Nov 2022 20:23:50 GMT

What about multiple conditions in the same measure/column?

Like this;

If(match(nativeCode, 1, 2, 3, ),'Minor severity')

If(match(nativeCode, 4, 5, 6, ),'Medium severity')

If(match(nativeCode, 7, 8, 9, ),'Critical')