Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-01-21 09:20 AM

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!

Labels (1)
Labels
972 Views
0 Likes
0 Replies