topic Help with expression in QlikView

Help with expression

hopkinsc — Mon, 13 Feb 2012 14:23:27 GMT

Hi, i am trying to get an expression to show me TotalValue of some Stock Movement Reason Codes but excludding some descriptions...

My fields are:

StockValue

Stock movement Reason Code

Narrative

I want the sum of StockValue for Stock Movement Reason Codes '3,5,16,18' but exclude values with a Narrative of either 'WASTAGE' or 'DAMAGED'

I have the following working for the first part..

sum ( {<[Stock Movement Reason Code] ={3, 5,16,18}>} StockValue)

but i am unsure on how to add the 2nd part.

Can anyone help please?

Thanks

CELAMBARASAN — Mon, 13 Feb 2012 14:29:34 GMT

Hi,

Check with this,

sum ( {<[Stock Movement Reason Code] ={'WASTAGE','DAMAGED'}>} StockValue)

Celambarasan

hopkinsc — Mon, 13 Feb 2012 14:32:36 GMT

Hi, thanks but that doesn't work.

I need it to INCLUDE Stock Movement Reason Code 3, 5,16,18 and EXCLUDE Narratives WASTAGE and DAMAGED.

Thanks

CELAMBARASAN — Mon, 13 Feb 2012 14:34:13 GMT

Hi,

Sorry wrongly understood your problem.

Here is the solution

sum ( {<[Stock Movement Reason Code] ={3, 5,16,18},Narrative-={'WASTAGE','DAMAGED'}>} StockValue)

Hope it helps

Celambarasan

Anonymous — Mon, 13 Feb 2012 14:35:48 GMT

Hi There,

Try this (assuming Narrative is also a field):

=Sum( {$ <[Stock Movement Reason Code] = {3,5,16,18} , [Narrative] -= {'WASTAGE','DAMAGED'}>}StockValue)

Is this what you are looking for?

hopkinsc — Mon, 13 Feb 2012 14:36:49 GMT

Thats great, thanks very much