topic Re: QUESTION in QlikView

QUESTION

nevilledhamsiri — Sat, 12 Aug 2017 17:06:43 GMT

Hi,

Appreciate, if looked in to how accurate it is written in the script!. There are number of products which are refered to as different classes such as

MC,M3,M4,FR,MS,HH,TC,PP,SA etc.

above are in a field which is named as class_code, when I load the said field, what I need is to catergorize them in to two main classes namely MO & NM thereby create a new field as MONM. Please see the way I have done.

Load,

Class_code,

if (Class_code='mc','motor',if(class_code='m3','motor',if(class_code='m4','motor,'nonmotor' as monm,

The issue is once it is done, catergorization is not properly done. Look forward to a reply.

Thanks

Neille.

Re: QUESTION

passionate — Sat, 12 Aug 2017 17:20:47 GMT

Try:

pick(Match(Class_code,'mc','m3','m4')+1,'nonmotor','motor','motor','motor')

Re: QUESTION

nevilledhamsiri — Sun, 13 Aug 2017 04:13:35 GMT

Dear Pnkaj,

Thanks, It worked well.

Re: QUESTION

passionate — Sun, 13 Aug 2017 06:44:35 GMT

Hi Neville,

Please mark the answer correct if your query is resolved.

The thread can be closed.

Thanks and Regards,

Pankaj