topic How to take first two digits from number? in QlikView https://community.qlik.com/t5/QlikView/How-to-take-first-two-digits-from-number/m-p/208423#M1207994 <HTML><HEAD></HEAD><BODY><P>Dear QlikView users,</P><P></P><P>As a beginner I have a question- how to take the first two digits of the number into consideration? My ArticleNumber is 010204-02 and the first two digits tell me that it's frozen food. I made cathegories for product type and now I would like to link it with ArticleNumber.</P><P>I would appreciate help,</P><P>Have a nice day,</P><P>Beata</P></BODY></HTML> Thu, 14 Jan 2010 12:06:44 GMT 2010-01-14T12:06:44Z How to take first two digits from number? https://community.qlik.com/t5/QlikView/How-to-take-first-two-digits-from-number/m-p/208423#M1207994 <HTML><HEAD></HEAD><BODY><P>Dear QlikView users,</P><P></P><P>As a beginner I have a question- how to take the first two digits of the number into consideration? My ArticleNumber is 010204-02 and the first two digits tell me that it's frozen food. I made cathegories for product type and now I would like to link it with ArticleNumber.</P><P>I would appreciate help,</P><P>Have a nice day,</P><P>Beata</P></BODY></HTML> Thu, 14 Jan 2010 12:06:44 GMT https://community.qlik.com/t5/QlikView/How-to-take-first-two-digits-from-number/m-p/208423#M1207994 2010-01-14T12:06:44Z How to take first two digits from number? https://community.qlik.com/t5/QlikView/How-to-take-first-two-digits-from-number/m-p/208424#M1207995 <HTML><HEAD></HEAD><BODY><P>Hello Beata,</P><P>If you have not used Num() function with that field, just try</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Left(ArticleNumber, 2) AS Category</PRE></BLOCKQUOTE>so you can use it. <BR /><BR /></BODY></HTML> Thu, 14 Jan 2010 12:59:12 GMT https://community.qlik.com/t5/QlikView/How-to-take-first-two-digits-from-number/m-p/208424#M1207995 Miguel_Angel_Baeyens 2010-01-14T12:59:12Z How to take first two digits from number? https://community.qlik.com/t5/QlikView/How-to-take-first-two-digits-from-number/m-p/208425#M1207996 <HTML><HEAD></HEAD><BODY><P>Thank you , yes it works- I used it by I didn't put <I>as Cathegory</I> (so already existing name in script).</P><P></P><P>Great!</P><P>Have a nice day,</P><P>Beata</P></BODY></HTML> Thu, 14 Jan 2010 13:13:24 GMT https://community.qlik.com/t5/QlikView/How-to-take-first-two-digits-from-number/m-p/208425#M1207996 2010-01-14T13:13:24Z