Qlik Sense : No RegEx, another option ?

Fri, 04 Nov 2016 09:13:39 GMT

Hi everyone,

In the code below, I create a new field "GroupeMonde" indicating a category for each element of the field "Monde". To do that, I point out all items included in each category each time.

This time I managed to make my category because there was not a lot of different elements inside, but having another category to achieve, including many other things, I have to try another way to make it.

From my research, it is impossible to use regular expressions in Qlik Sense, or even via a VBScript as it is possible to do on Qlik View. How to do it?

Thank you for your help,

Alex.

LOAD

    Trigramme,

    Secours,

    "Date dernier test",

    Monde,

    "Application secourue",

    "Criticité STAMP",

//CREATION OF FIELD GroupeMonde

      If(Monde='Windows'

          or Monde='Autres, UNIX-LINUX'

          or Monde='UNIX-AIX'

          or Monde='UNIX-AIX, UNIX-ESX, Windows'

          or Monde='UNIX-AIX, UNIX-LINUX'

          or Monde='UNIX-AIX, UNIX-LINUX, UNIX-SUN'

          or Monde='UNIX-AIX, UNIX-LINUX, UNIX-SUN, Windows'

          or Monde='UNIX-AIX, UNIX-LINUX, Windows'

          or Monde='UNIX-AIX, UNIX-SUN'

          or Monde='UNIX-AIX, Windows'

          or Monde='UNIX-ESX, Windows'

          or Monde='UNIX-HP'

          or Monde='UNIX-LINUX'

          or Monde='UNIX-LINUX, UNIX-SUN'

          or Monde='UNIX-LINUX, UNIX-SUN, Windows'

          or Monde='UNIX-LINUX, Windows'

          or Monde='UNIX-SUN'

          or Monde='UNIX-SUN, Windows', Dual('SDI', 1),



           If(Monde='MVS', Dual('Mainframe', 2),



               If(Monde='MVS, UNIX-AIX'

                  or Monde='MVS, UNIX-AIX, UNIX-LINUX, Windows'

                  or Monde='MVS, UNIX-AIX, UNIX-SUN'

                  or Monde='MVS, UNIX-LINUX'

                  or Monde='MVS, UNIX-LINUX, UNIX-SUN'

                  or Monde='MVS, UNIX-LINUX, Windows'

                  or Monde='MVS, Windows', Dual('Mixste', 3),



                      If(Monde='Autres', Dual('Autres', 4),



                          If(Monde='<NULL>', Dual('<NULL>', 5),

                             ))))) as GroupeMonde

Re: Qlik Sense : No RegEx, another option ?

Tue, 08 Nov 2016 08:32:58 GMT

Have you considered doing it as a resident load? Then you can group the categorisations to different levels.

topic Re: Qlik Sense : No RegEx, another option ? in App Development

Qlik Sense : No RegEx, another option ?

Re: Qlik Sense : No RegEx, another option ?