topic Error with not equal to in expression @ pivot table in QlikView

Error with not equal to in expression @ pivot table

Tue, 28 Apr 2015 14:54:47 GMT

Hi,

In pivot table, I'm trying to write the following expression

SUM({<[Cyence User Status] <> {'Disabled'}>}[Cyence Credit Approval Limit]) , but the system says error in modifier. But when I write,

SUM({<[Cyence User Status] = {'Disabled'}>}[Cyence Credit Approval Limit])

it works fine.

Can someone please help me with not equal to expression.

Thank you in advance.

Regards,

Adi

ramoncova06 — Tue, 28 Apr 2015 15:00:58 GMT

SUM({<[Cyence User Status] -= {'Disabled'}>}[Cyence Credit Approval Limit])

the <> does not work in the set analysis use "-=" instead

Tue, 28 Apr 2015 15:07:29 GMT

Thanks Ramon!!!