Question regarding field value within parenthesis

[#1]

I have 2 fields that both contain the value (Inventory)  - the parenthesis is included in the field value

Whenever I have tried to do set analysis, such as Customer -={(Inventory)} or Customer -=('(Inventory')'}, the condition always fails (have done as an equal test as well but that test fails as well).

I then tried to modify my load script to do the following

LOAD*,
If ([Customer] = '(Inventory)','-Inventory') as Inventory;

The field inventory is crated but contains nulls.  If I replace (Inventory) with any other value that does not include parenthesis, the if test and set analysis works successfully

[malini_qlikview · Accepted solution]

try Customer -={'*(Inventory)'}

[Digvijay_Singh]

Try like this -

= Sum({<ProdType-={"=ProdType='(Inventory)'"}  >} Sales)

[#4]

This appears to work!!

Thanks