set analysis 'not equal to ' syntax

[#1]

Hi All,

I want to achieve the foll: with set analysis

count of id where field a<> field b

i tried  '<>' and '-='.

But, both did not work.

Please help me out.

Thanks,

Anju

[cn_sa_dev]

Can you upload the document or a sample with the issue?

[#3]

PFA.

I have written the equivalent expression using if statement.

But, I want to write the same using set analysis and make it

independent of selections.

Thanks,

Anju

[Gysbert_Wassenaar]

Try:

=COUNT({1<MER_MATCH_MASK={'3'},RUN_DATE = {'$(vMaxDate)'},MTR_ID={'=MPCS_WLDTI<>SDP_WLDT'}>}MTR_ID)

[#5]

Hi,  try with this setAnalysis,     using:     =- 

In this example : exculye all employee with state are I or T.

Count({<HC_ESTADO =-{'I','T'},_Origen>}HC_CODEMP)

Regards!.

[Anonymous]

Try:

Dimension = {'*'}-{'Value you don't want'}

Meaning give me everything minus the values not equal to.

[cn_sa_dev]

Hi Anju,

This is working for me on your example, just add in the other operators you need.

count({<MPCS_WLDTI={'1','0'}, SDP_WLDTI={'1','0'}>

        - <MPCS_WLDTI={'1'}, SDP_WLDTI={'1'}>

        - <MPCS_WLDTI={'0'}, SDP_WLDTI={'0'}>} distinct MTR_ID)

Kind regards,

Chris

[#8]

Thanks for replying.

But , it returns 0.

[#9]

Hi,

i wanted to use the field names, not the field values..

[cn_sa_dev · Accepted solution]

i.e.

=

(count({<MPCS_WLDTI={'1','0'}, SDP_WLDTI={'1','0'},MER_MATCH_MASK={'3'},RUN_DATE = {'$(vMaxDate)'}>

        - <MPCS_WLDTI={'1'}, SDP_WLDTI={'1'},MER_MATCH_MASK={'3'},RUN_DATE = {'$(vMaxDate)'}>

        - <MPCS_WLDTI={'0'}, SDP_WLDTI={'0'},MER_MATCH_MASK={'3'},RUN_DATE = {'$(vMaxDate)'}>} distinct MTR_ID)

)

[cn_sa_dev]

Hi Anju,

Was this helpful?

Regards,

Chris