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:
right(ProductDescription,4)
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!