Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

Search Issue with QV 11.2 SR4 access point

hi

i have an issue with the search. In a multiple box, i look for ZIP codes. I just want two of them as indicated 50-579 or 50515. The search displays other values too, what i do not understand why, like ÖRIMGE and "or" (but is a logical connector!)

The final result is in the table below, marked in green, and QV selects all four results, even though i look for two zip codes.

The same happened when looking from a list of numbers (all different) from 1 to 100. I searched like this : "2 or 3 or 45" and QV displayed all selections as wildcard, even though the search setting for the document is "normal".  I wanted only 3 values, but the end result was all possible like 2,3,20,21,22,23,...30,31... 45,46,.... with more than 20 values. This leads to bad results.

Is the "or" correct? or what should i use there? (listbox/multibox). Users don't want to use CTRL + Selection, because sometimes  we need more than 10 values which are not in order (or sequential)

thanks for any insight here

felipe


ZIP Code.png

customerzip.png

1 Solution

Accepted Solutions
christian77
Partner - Specialist
Partner - Specialist

En el teclado, (es un lap top?), en la fila de número superior, hay unos símbolos, como el de euro de la tecla E, que salen pulsando Alt Gr y la tecla correspondiente.

En el 1 está el pipe.

Si no, alt 124.

Yo uso Word para buscar los códigos de los símbolos, (viví en USA y no había ñ en los teclados), insertar símbolo y mirar el código de carácter en ASCII decimal.

View solution in original post

11 Replies
jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

that occurs because in this case, 'OR' doesn't work as a logical operator. If you want to search either 50-579 or 50515, you need to type it as 50-579 + 50-515, so the search perform a union (or).

regards

felcar2013
Partner - Creator III
Partner - Creator III
Author

that worked, but from my list below, I look only for 3 or 5 and it selects everything, even though i did not perform a wildcard search. It did not work neither with "or" nor "+". How should i look here if i want to look for exactly some numbers? QV selects not only the 2 values i am looking for but all of the marked values with yellow (in the ex. i used 2, but what if i need to look for more and the list is my customer Id with millions of values)

how the search string shall look like?

cusduration1.png

cusduration2.png

christian77
Partner - Specialist
Partner - Specialist

Hi Felipe.

When you seach, type (50-515|50-579).

It Works.

felcar2013
Partner - Creator III
Partner - Creator III
Author

hi Christian

no, it does not work with this version. Besides, ZIP codes seems not to be so bad, but when trying with the integers and looking for just 5 or 6 it selects all numbers containing a 5. When i press enter to select it selects everything, even though i just want the five + (or) 6

christian77
Partner - Specialist
Partner - Specialist

For the last list you should do (3|5)

It shoul work.

The simbol | (Pipe) is Alt Gr + 1.

If it does not work, then select 3 and then with the control key pressed, select 5.

christian77
Partner - Specialist
Partner - Specialist

To avoid selecting everything with five, take away the star (*)

felcar2013
Partner - Creator III
Partner - Creator III
Author

i did not use the pipe, but i just use () and it worked. Like this  (5) or (6) or (9) and qv selected exactly 5, 6 and 9

and not all wildcard combinations.

apropo, i did not use the *, this is why i found it strange, since the default settings for this document are "normal" search

thanks

christian77
Partner - Specialist
Partner - Specialist

Yo uso la 11.2 SR4 y funciona. (A|B) selecciona A y B.

felcar2013
Partner - Creator III
Partner - Creator III
Author

el pipe no me sale con alt gr +1 sino con alt + 179, y cuando lo uso y doy enter, no selecciona los numeros que quiero sino otra lista mucho mas larga.