topic Re: set analysis 'not equal to ' syntax in QlikView

set analysis 'not equal to ' syntax

Thu, 31 Oct 2013 12:50:09 GMT

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

Re: set analysis 'not equal to ' syntax

mjm — Thu, 31 Oct 2013 12:55:31 GMT

Hello Anju,

Can you please provide a full example of the set analysis statement which you are using? What exactly is it you are trying to achieve with this Set Analysis statement?

Re: set analysis 'not equal to ' syntax

Thu, 31 Oct 2013 12:58:30 GMT

=COUNT({1<A<>B>}ID)

something like this.. but the syntax is wrong...

Re: set analysis 'not equal to ' syntax

Thu, 31 Oct 2013 13:01:54 GMT

I would rather do

count({$ or 1 <A = {"A<>B"} >} ID)

Fabrice

Re: set analysis 'not equal to ' syntax

kaushalview — Thu, 31 Oct 2013 13:02:05 GMT

Hi,

Use syntax -= in set analysis and without set analysis expression <>

Example:

Count({<Country-={'U.S'}>})

Regards

Kaushal Mehta

Re: set analysis 'not equal to ' syntax

Clever_Anjos — Thu, 31 Oct 2013 13:04:50 GMT

Maybe this can solve your need

=COUNT({<A=A-P(B)>}ID)

Re: set analysis 'not equal to ' syntax

israrkhan — Thu, 31 Oct 2013 13:05:24 GMT

try

if(A<>B, Count(ID))

and make sure , The Field Name are In same Caps, if You have field in Database like small a, and you use Capital A in set analysis,i will not work, qlikview is case sensitive...

Re: set analysis 'not equal to ' syntax

cn_sa_dev — Thu, 31 Oct 2013 13:09:14 GMT

Hi Anju,

"-=" Does work for "not equal to" despite showing a syntax error. It will underline the statement in red, but the top of the Edit Expression bar will still read "Expression Ok" and it will return the correct data.

Regards,

Chris

Re: set analysis 'not equal to ' syntax

Thu, 31 Oct 2013 13:17:05 GMT

Hi Chris,

I tried this

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

it shows a red line under mtr_id , but returns the wrong answer..

it returns the answer satisfying only conditions for mer_match_mask & run_date and

ignores mpcs_wldti

Re: set analysis 'not equal to ' syntax

Thu, 31 Oct 2013 13:19:39 GMT

Hi,

I tried this.But it did not work.

=COUNT({<MPCS_WLDTI=MPCS_WLDTI-P(SDP_WLDTI)}>}MTR_ID)

Re: set analysis 'not equal to ' syntax

cn_sa_dev — Thu, 31 Oct 2013 13:20:56 GMT

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

Re: Re: set analysis 'not equal to ' syntax

Thu, 31 Oct 2013 14:05:30 GMT

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

Re: set analysis 'not equal to ' syntax

Gysbert_Wassenaar — Thu, 31 Oct 2013 15:05:21 GMT

Try:

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

Re: set analysis 'not equal to ' syntax

Thu, 31 Oct 2013 15:12:40 GMT

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

Re: set analysis 'not equal to ' syntax

Anonymous — Thu, 31 Oct 2013 15:17:56 GMT

Try:

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

Meaning give me everything minus the values not equal to.

Re: set analysis 'not equal to ' syntax

cn_sa_dev — Mon, 04 Nov 2013 09:21:44 GMT

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

Re: set analysis 'not equal to ' syntax

Tue, 05 Nov 2013 10:54:11 GMT

Thanks for replying.

But , it returns 0.

Re: set analysis 'not equal to ' syntax

Tue, 05 Nov 2013 10:55:05 GMT

Hi,

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

Re: set analysis 'not equal to ' syntax

cn_sa_dev — Tue, 05 Nov 2013 12:47:11 GMT

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)

)

Re: set analysis 'not equal to ' syntax

cn_sa_dev — Mon, 11 Nov 2013 10:11:31 GMT

Hi Anju,

Was this helpful?

Regards,

Chris