Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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

5 Replies
krishnacbe
Not applicable

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

Hi,

Try below expression.

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

vamsee
Not applicable

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

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
Not applicable

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

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

 

psankepalli
Not applicable

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

Sorry there was typo,


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

 

jontydkpi
Not applicable

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein