2 Replies Latest reply: Dec 6, 2010 8:37 AM by Roland Kunle RSS

    Help with expression

    Chris Hopkins

      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?