topic and/ or for left, right function in QlikView https://community.qlik.com/t5/QlikView/and-or-for-left-right-function/m-p/219090#M715253 <HTML><HEAD></HEAD><BODY><P>Dear QlikViewers,</P><P></P><P>I have a kind of stupid problem- I'm trying to link products into cathegories, with:</P><P><I>left(artcode,2) as ProductGroupNumber</I> and everything works great. But now I need to distinguish between one more group, that's taken from ProductDesription:</P><P style="font-style: italic">right(ProductDescription,4)</P><P>I tried to make it in script, but it seems I am not able:( I used:</P><P style="font-style: italic">left(artcode,2) &amp; right(ProductDescription,4) as ProductGroupNumber</P><P style="font-style: italic">left(artcode,2) or right(ProductDescription,4) as ProductGroupNumber</P><P>How can I make it?</P><P>Thanks a lot!</P><P></P></BODY></HTML> Thu, 21 Jan 2010 14:20:43 GMT 2010-01-21T14:20:43Z and/ or for left, right function https://community.qlik.com/t5/QlikView/and-or-for-left-right-function/m-p/219090#M715253 <HTML><HEAD></HEAD><BODY><P>Dear QlikViewers,</P><P></P><P>I have a kind of stupid problem- I'm trying to link products into cathegories, with:</P><P><I>left(artcode,2) as ProductGroupNumber</I> and everything works great. But now I need to distinguish between one more group, that's taken from ProductDesription:</P><P style="font-style: italic">right(ProductDescription,4)</P><P>I tried to make it in script, but it seems I am not able:( I used:</P><P style="font-style: italic">left(artcode,2) &amp; right(ProductDescription,4) as ProductGroupNumber</P><P style="font-style: italic">left(artcode,2) or right(ProductDescription,4) as ProductGroupNumber</P><P>How can I make it?</P><P>Thanks a lot!</P><P></P></BODY></HTML> Thu, 21 Jan 2010 14:20:43 GMT https://community.qlik.com/t5/QlikView/and-or-for-left-right-function/m-p/219090#M715253 2010-01-21T14:20:43Z