How to take first two digits from number?

[#1]

Dear QlikView users,

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.

I would appreciate help,

Have a nice day,

Beata

[Miguel_Angel_Baeyens · Accepted solution]

Hello Beata,

If you have not used Num() function with that field, just try

Left(ArticleNumber, 2) AS Category

so you can use it.

[#3]

Thank you , yes it works- I used it by I didn't put as Cathegory (so already existing name in script).

Great!

Have a nice day,

Beata