topic Not equal in QlikView

Not equal

Mon, 02 Apr 2012 19:06:40 GMT

Hi All,

Anybody has any idea why my not equal is not good? It gives me syntax error.

sum({$<DIVISION={'IDG'},[TERRITORY DESC E] - ={'Export'}> }WEIGHT )

Thanks,

Not equal

m_woolf — Mon, 02 Apr 2012 20:00:00 GMT

remove space after the -

Not equal

Mon, 02 Apr 2012 20:03:23 GMT

I put the space here just to show it clearly but originally there is no space.

And still there is a syntax error.

Not equal

swuehl — Mon, 02 Apr 2012 20:21:57 GMT

I believe there is still (QV11 IR) a bug in the expression dialog that marks the -= set operator incorrectly as syntax error. The status should say 'expression OK' though and the expression should be evaluated.

Not equal

Mon, 02 Apr 2012 20:41:24 GMT

The experession works but syntax checking shows an error.

It's funy anyway. Just wanted to make sure that what I see it ok?

Thanks

Not equal

erichshiino — Tue, 03 Apr 2012 03:12:49 GMT

There are many set analysis expressions that are not recognized by this syntax checker lilke this operator or many cases of indirect set analisys.

I'm afraid it's not just on QV 11, I'd say it comes from version 9 or 10...

Regards,

Erich