QlikView Date fields

[everest226]

HI i have a field Name FTR   , it has a value H,D,A

now i want new field if the value is H and A then 3  , D then 1 

[waszcma1 · Accepted solution]

Hi, 

So use that:

if(wildmatch(FTR ,'H','A'),3,1)

[sgagliardi]

Do you mean:

=IF(FTR='H',3,IF(FTR='A',3,1))