8 Replies Latest reply: Apr 23, 2015 9:22 AM by Michael Tarallo RSS

    Global Smart Search need

    Sofiene Khayati

      Hi,

       

      How to find the words that begin with "A" and ended with "T" and contains "B" in the middle with Qlik Sense - Global Smart Search it was possible in QlikView 11 ?

       

      Why we can't do it now ?

       

      Reference : Qlik Sense - Global Smart Search (video)

       

       

      Regards,

        • Re: Global Smart Search need
          Rajesh Vaswani

          Hi,

           

          Use the following pattern in the search to look for the word

           

          A*B*T

           

          thanks,

          Rajesh Vaswani

          • Re: Global Smart Search need
            jagan mohan rao appala

            Hi,

            You can use wildcard characters for that, try something like

            A*B*T


            Hope this helps you.


            Regards,

            Jagan.

            • Re: Global Smart Search need
              Sofiene Khayati

              Hi,

              I have tested before asking my question!

              It's not working !!

              Search.PNG


              The reference that its not working : Qlik Sense - Global Smart Search (video)

               

              ref.PNG

                • Re: Global Smart Search need
                  jagan mohan rao appala

                  Hi,

                   

                  Check this in Qliksense manual

                   

                  help.qlik.com/sense/en-US/online/#../Subsystems/Hub/Content/Search/TextSearch.htm

                   

                  Wildcards

                  You can use one or several wildcards in a search string. The following wildcards can be used:

                  WildcardRepresentation
                  *Zero or more characters, including blank. This wildcard is flexible and matches any character or any block of characters in a specific position.
                  ?A single character, including blank. This wildcard is useful when you suspect that a string may be misspelt, when you are unsure of the spelling, or when the string contains special characters that may be difficult to reproduce correctly.
                  ExampleResult
                  a*Finds all values that begin with the letter 'a', including strings with several words where the first word begins with an 'a'.
                  *bFinds all values that end with the letter 'b', including strings with several words where the last word ends with a 'b'.
                  *c*Finds all values that contain the letter 'c', including strings with several words.
                  r?ckFinds all values that have four letters and start with an 'r', followed by any character, and ending with'ck', for example, 'rack', 'rick', 'rock', and 'ruck'
                  r?? ????dFinds all values that consist of a three-letter word beginning with an 'r' and a five-letter word ending with a 'd'

                  Regards,

                  Jagan.