This content has been marked as final. Show 2 replies
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 :
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?