topic Re: General if statement in QlikView

General if statement

markgraham123 — Mon, 14 Aug 2017 15:43:54 GMT

Hi,

I'm trying to create a new fileds using and in if statement. But i'm not getting any result.

But a simple if statement is not working. I know there should be something wrong in my syntax.

Can someone please help?

Table1:

LOAD * Inline

[

ID, Name

1,A

1,B

1,C

1,D

1,E

];

Table2:

LOAD *,

If(Name='A' and Name='B' and Name='D' and Name='D' and Name='E' , 'special') as test

Resident Table1;

DROP Table Table1;

Re: General if statement

Anil_Babu_Samineni — Mon, 14 Aug 2017 15:47:59 GMT

May be this?

If(Name='A' or Name='B' or Name='D' or Name='D' or Name='E' , '5', Name) as test

Re: General if statement

Anonymous — Mon, 14 Aug 2017 15:48:45 GMT

Name cannot be A and B and D ...

it could be A or B fr example

Re: General if statement

markgraham123 — Mon, 14 Aug 2017 15:53:28 GMT

No Anil.

ID can have multiple names.

Depending on what names the ID has i havre to create a category field.

Above is one of the example.

Re: General if statement

markgraham123 — Mon, 14 Aug 2017 15:53:53 GMT

ID can have multiple names.

Depending on what names the ID has i havre to create a category field.

Above is one of the example.

Re: General if statement

Anil_Babu_Samineni — Mon, 14 Aug 2017 15:54:59 GMT

Then, you must explain real data which demonstrates the issue

Re: General if statement

Anonymous — Mon, 14 Aug 2017 15:56:51 GMT

??? could you elaborate it a bit more please?

Re: General if statement

vishsaggi — Mon, 14 Aug 2017 16:05:22 GMT

Try this may be?

If(Match(Name, 'A','B','C','D','E'), 'Special') as test

Re: General if statement

el_aprendiz111 — Mon, 14 Aug 2017 17:01:11 GMT

Hi Mark

/option 1
Table1:
LOAD *, if(WildMatch(Name,'A','B','D','E'),'SPE','OTHER') AS newFieldTest;
LOAD * Inline
[
ID, Name
1,A
1,B
1,C
1,D
1,E
];

//option 2
CHRS:MAPPING LOAD * INLINE [
Name, Test
A, SPE
B, SPE
C, OTHER
D, SPE
];

Table1:
LOAD *, ApplyMap('CHRS',Name,'OTHER') AS newFieldTest;
LOAD * Inline
[
ID, Name
1,A
1,B
1,C
1,D
1,E
];

Re: General if statement

eduardo_dimperio — Mon, 14 Aug 2017 17:33:52 GMT

Mark, i dont know if i right understant, but Id could have multiple values, but only one per line.

Name could be A or B or C or D or E, but not all at the same time.

So change your AND to OR.

Re: General if statement

MarcoWedel — Mon, 14 Aug 2017 21:29:53 GMT

Hi,

I guess you're looking for a category based on the actual name sequence, so one solution to this problem might be:

mapCategory:
Mapping LOAD * Inline [
NameSequence, Category
ABCDE, normal
ABDDE, special
EDCBA, reverse
];

Table1:
LOAD * Inline
[
ID, Name
1,A
1,B
1,C
1,D
1,E
2,A
2,B
2,D
2,D
2,E
3,E
3,D
3,C
3,B
3,A
];

Join
LOAD ID,
    ApplyMap('mapCategory',Concat(Name,'',RecNo())) as Category
Resident Table1
Group By ID;

hope this helps

regards

Marco