Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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:

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!

0 Replies