topic Re: Multiple options in calculated dimension in QlikView

Multiple options in calculated dimension

Thu, 03 Sep 2015 10:06:31 GMT

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 — Thu, 03 Sep 2015 10:10:01 GMT

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

Hope this helps

alexandros17 — Thu, 03 Sep 2015 10:10:25 GMT

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

let me know

maleksafa — Thu, 03 Sep 2015 10:10:27 GMT

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 — Thu, 03 Sep 2015 10:10:52 GMT

Try this:

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