Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you upload the document or a sample with the issue?
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
Try:
=COUNT({1<MER_MATCH_MASK={'3'},RUN_DATE = {'$(vMaxDate)'},MTR_ID={'=MPCS_WLDTI<>SDP_WLDT'}>}MTR_ID)
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!.
Try:
Dimension = {'*'}-{'Value you don't want'}
Meaning give me everything minus the values not equal to.
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
Thanks for replying.
But , it returns 0.
Hi,
i wanted to use the field names, not the field values..
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)
)
Hi Anju,
Was this helpful?
Regards,
Chris