# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

## Where not Match

Hi I'm trying to create a calculated dimension where the values are 'Both', 'GLS/HT', 'Encore', or 'Neither' but the 'Neither' isn't working. this is what I have so far:

=

IF(

Match([Workday.W_CODE],[GLS.W_CODE]) AND Match([Workday.W_CODE],[Encore.W_CODE])

, 'Both'

, IF(

Match([Workday.W_CODE],[GLS.W_CODE])

, 'GLS/HT'

, IF(

Match([Workday.W_CODE],[Encore.W_CODE])

, 'Encore'

, IF(

Match([Workday.W_CODE],[Encore.W_CODE],[GLS.W_CODE])=0

,'Neither')

)

)

)

Please let me know if you have any ideas to fix it!

Thanks

1 Solution

Accepted Solutions
Contributor III

## Re: Where not Match

=

IF(

Match([Workday.W_CODE],[GLS.W_CODE]) AND Match([Workday.W_CODE],[Encore.W_CODE])

, 'Both'

, IF(

Match([Workday.W_CODE],[GLS.W_CODE])

, 'GLS/HT'

, IF(

Match([Workday.W_CODE],[Encore.W_CODE])

, 'Encore'

, IF(

Match([Workday.W_CODE],[Encore.W_CODE],[GLS.W_CODE])=0

'ZeroValue','Neither')

)

)

)

5 Replies
Esteemed Contributor

## Re: Where not Match

Hi,

can you attach some sample data ?

Contributor II

## Re: Where not Match

I saw it on another thread Where not match?

Esteemed Contributor

## Re: Where not Match

Sorry I deleted the first message because I was maybe wrong..

would you be able to attach some data ?

Contributor II

## Re: Where not Match

IF(

Match([Workday.W_CODE],[GLS.W_CODE]) AND Match([Workday.W_CODE],[Encore.W_CODE])

, 'Both' ,
IF( Match([Workday.W_CODE],[GLS.W_CODE])

, 'GLS/HT',
IF( Match([Workday.W_CODE],[Encore.W_CODE])
, 'Encore',
IF( Match([Workday.W_CODE],[Encore.W_CODE],'Neither')

)

)

)

IF( Match([Workday.W_CODE],[Encore.W_CODE])

and  the next ceil  idnetity

IF( Match([Workday.W_CODE],[Encore.W_CODE]

you see no datas

Contributor III

## Re: Where not Match

=

IF(

Match([Workday.W_CODE],[GLS.W_CODE]) AND Match([Workday.W_CODE],[Encore.W_CODE])

, 'Both'

, IF(

Match([Workday.W_CODE],[GLS.W_CODE])

, 'GLS/HT'

, IF(

Match([Workday.W_CODE],[Encore.W_CODE])

, 'Encore'

, IF(

Match([Workday.W_CODE],[Encore.W_CODE],[GLS.W_CODE])=0

'ZeroValue','Neither')

)

)

)