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

[#1]

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

[krishnacbe]

Hi,

Try below expression.

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

[vamsee]

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

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

[psankepalli]

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

[psankepalli]

Sorry there was typo,

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

[jonathandienst]

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