Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis 'not equal to ' syntax

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

22 Replies
cn_sa_dev
Partner
Partner

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

Not applicable
Author


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)


talk is cheap, supply exceeds demand
Not applicable
Author

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!.

rodrick
Creator
Creator

Try:

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

Meaning give me everything minus the values not equal to.

cn_sa_dev
Partner
Partner

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

Not applicable
Author

Thanks for replying.

But , it returns 0.

Not applicable
Author

Hi,

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

cn_sa_dev
Partner
Partner

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
Partner
Partner

Hi Anju,

Was this helpful?

Regards,

Chris