topic Why is this expression not working? in QlikView

Why is this expression not working?

Wed, 28 Aug 2013 12:06:23 GMT

I have the following expression.

if([RecordType] <> 'ExPL' OR [RecordType] <> 'ExDE' OR [RecordType] <> 'ExFR',

if(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue]) > 1000000,
Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue])/1000,'#.##0M;-#.##0M'),
Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000'  , '305500'  ,'51062'  , '50339', '10339', '11678', '101230'}>} [InvoiceNetValue])/1000,'#.##0K;-#.##0K'))

,0)

First I want to make sure these 3 record types are excluded. Then I want to exclude the selected CustomerKeys.

The middle part works. the right customers are excluded. But whe I add the [RecordType] filter the result stays the same.

Re: Why is this expression not working?

CELAMBARASAN — Wed, 28 Aug 2013 12:09:43 GMT

try with this

if(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000' , '305500' ,'51062' , '50339', '10339', '11678', '101230'}, [RecordType] -={'ExPL', 'ExDE', 'ExFR'}>} [InvoiceNetValue]) > 1000000,

Num(Sum({<[CustomerKey]-={'106180' , '104300','105680' , '305000' , '305500' ,'51062' , '50339', '10339', '11678', '101230'},[RecordType] -={'ExPL', 'ExDE', 'ExFR'}>} [InvoiceNetValue])/1000,'#.##0M;-#.##0M'),

Celambarasan

Re: Why is this expression not working?

Wed, 28 Aug 2013 12:15:23 GMT

Worked perfectly. Thanks mate!