Help with expression

hopkinsc — Mon, 06 Dec 2010 11:04:01 GMT

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?

Help with expression

hopkinsc — Mon, 06 Dec 2010 12:04:05 GMT

Any help with this please ?

Help with expression

Mon, 06 Dec 2010 13:37:34 GMT

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

topic Help with expression in QlikView

Help with expression

Help with expression

Help with expression