Listbox Selections

[braham]

Morning all

I have two questions about the selection of values in a list box. It seems so basic, yet it is not working as I would expect. In our business we use an ICD code that has the following structure: J10, J10.0, J10.1, J10.2 ...J10.9, J11, J11.0, J11.1 etc. I would like to select a number of values and entered the following J10.1|J10.9|J11.2. Qlikview returns all the values for this code. If I enter "J10.1"|"J10.9"|"J11.2"  (ie within double quotes) I get a number of values returned, but still not 100% correct, as J10 and J11 are also returned. I have changed my search mode to normal. Within Qlikview I have also always used single quotes. This search only accepts double quotes. When should you use single and when should you use double quotes.

Thanks

Braham Edwards

[MK_QSL]

Try

(J10.1|J10.9|J11.2)

[sunny_talwar]

Try adding parenthesis to your search

("J10.1"|"J10.9"|"J11.2")

[braham · Accepted solution]

Thanks Manish, putting it in brackets works.

[MK_QSL]

Then you should have selected my answer as correct... LOL

[sunny_talwar]