0 Replies Latest reply: Jan 21, 2010 9:20 AM by beciafreestyle RSS

    and/ or for left, right function


      Dear QlikViewers,


      I have a kind of stupid problem- I'm trying to link products into cathegories, with:

      left(artcode,2) as ProductGroupNumber and everything works great. But now I need to distinguish between one more group, that's taken from ProductDesription:


      I tried to make it in script, but it seems I am not able:( I used:

      left(artcode,2) & right(ProductDescription,4) as ProductGroupNumber

      left(artcode,2) or right(ProductDescription,4) as ProductGroupNumber

      How can I make it?

      Thanks a lot!