Help with expression

[hopkinsc]

Hi,

I need to write an expression for any EAN ending with 6 0's, StockQty otherwise Sum(StockQty). but not completely sure how to tell qlikview to look at the last 6 digits of the EAN...

Currently my expression is just :

Sum(StockQty)

but i have noticed that this expression doesn't work for any EANS ending with 6 0's (5020521000000). I now realise that i can't sum these items up, they need to be seperated to be able to give the correct figure.

so i need an expression that will just display the StockQty for EANS ending in 6 0's, but sum(StockQty) for all other EANS.

Can anyone help please?

[hopkinsc]

Any help with this please ?

[#3]

Hello Hopkinsc,

you can try in your expression the good old if() like this:

sum( if(Right(EAN,6) = '000000', Qty))

and

sum( if(Right(EAN,6) <> '000000', Qty))

HtH

Roland