topic Re: How to write "not equals to" condition in set analysis? in QlikView

How to write "not equals to" condition in set analysis?

Thu, 12 Oct 2017 11:55:59 GMT

Hi,

I am trying to write a set analysis expression for not equal to condition.

Requirement:

List products where Brand is not equals to 'B'

Please advise.

Thanks,

Chethan.V

Re: How to write "not equals to" condition in set analysis?

krishnacbe — Thu, 12 Oct 2017 19:47:21 GMT

Hi,

Try below expression.

Only({<Brand-={"B"}>}products)

Re: How to write "not equals to" condition in set analysis?

vamsee — Thu, 12 Oct 2017 20:00:39 GMT

For versions of Qlikview earlier than 12.0 {<Brand={'*'}-{'B'}>}

When " " -- are used, the value inside it is calculated. For text use ' ' (single quotes)

Re: How to write "not equals to" condition in set analysis?

psankepalli — Fri, 13 Oct 2017 04:34:56 GMT

sum({$< Brand={'*'} - {'B'}>} Products)

Re: How to write "not equals to" condition in set analysis?

psankepalli — Fri, 13 Oct 2017 04:35:38 GMT

Sorry there was typo,

Only({$< ={'*'} - {'B'}>} APPTime)

Re: How to write "not equals to" condition in set analysis?

jonathandienst — Fri, 13 Oct 2017 04:58:27 GMT

>>For versions of Qlikview earlier than 12.0 {<Brand={'*'}-{'B'}>}

The -= syntax has worked since V10 (or perhaps even V9. The syntax checker incorrectly showed this as an error (red squiggly underline), but it worked correctly. The syntax checker was fixed in 11.20 SR 12 (or thereabout).

For list box or calculated dimension:

=Aggr(Only({<Brand -= {B}>} product), product)