topic Re: Question regarding field value within parenthesis in QlikView

Question regarding field value within parenthesis

Tue, 06 Oct 2015 14:58:24 GMT

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

Re: Question regarding field value within parenthesis

malini_qlikview — Tue, 06 Oct 2015 16:13:09 GMT

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

Re: Question regarding field value within parenthesis

Digvijay_Singh — Tue, 06 Oct 2015 16:22:50 GMT

Try like this -

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

Re: Question regarding field value within parenthesis

Tue, 06 Oct 2015 16:26:46 GMT

This appears to work!!

Thanks