1 Reply Latest reply: Nov 8, 2016 3:32 AM by Mikko Hartikainen RSS

    Qlik Sense : No RegEx, another option ?

    Alexandre Lepinet

      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