Multiple options in calculated dimension

[#1]

I have a calculated dimension expression like this:

=if([Type]='dogfo',[Type])

How do I write this statement so that I can include multiple fields: 'misse', 'flyti'?

[qlikmsg4u]

=If(wildmatch([Type],'dogfo','misse','flyti'),[Type])

Hope this helps

[alexandros17]

=if([Type]='dogfo',[Type], if([Type]='misse',[Field1],[Field2]))

let me know

[maleksafa]

what do you mean by multiple Fields?

you mean include those values in the if condition? if that's it then

=if( match([Type],'dogfo','misse','flyti'), [Type])

however i recommend not to use calculated dimensions and move them into the load script and use normal dimensions in your chart.

[sunny_talwar]

Try this:

If(WildMatch(Type, 'dogfo', 'misse', 'flyti'), Type)