topic Error using not equal in set analysis in QlikView

Error using not equal in set analysis

Sat, 07 Jun 2014 13:21:13 GMT

I am getting an error using the following set analysis:

=round(sum({<[Disti LOB]-={39},[CTA Duplicate]={'No'}>}$(vExtEffCommPrice))/1000)

The red squiggly line shows up on the left brace right before the 3.

Any suggestions?

I just want all records where Disti LOB <> 39

swuehl — Sat, 07 Jun 2014 13:28:59 GMT

The syntax checker in the expression editor isn't perfect. Marking operators like -= as error is a known bug.

Does the editor states 'Expression ok'? Does the expression return a value?

Sat, 07 Jun 2014 13:35:28 GMT

no i get error in calculation

nagaiank — Sat, 07 Jun 2014 14:30:38 GMT

Is [Disti LOB] a field?

If that field contains text values, you may use [Disti LOB] -= {"39"}

Also check if the variable vExtEffCommPrice has a valid expression.

MK_QSL — Sat, 07 Jun 2014 15:01:11 GMT

=round(sum({<[Disti LOB]={*'}-{'39'},[CTA Duplicate]={'No'}>}$(vExtEffCommPrice))/1000)