Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

etrotter
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
wdchristensen
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
YoussefBelloum
Esteemed Contributor

Re: Where not Match

Hi,

can you attach some sample data ?

etrotter
Contributor II

Re: Where not Match

I saw it on another thread Where not match?

YoussefBelloum
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 ?

gerry_hdm
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

wdchristensen
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')

                )

         )

)

Community Browser