topic Re: Listbox Selections in QlikView

Listbox Selections

braham — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Listbox Selections

MK_QSL — Mon, 19 Jun 2017 11:48:12 GMT

Try

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

Re: Listbox Selections

sunny_talwar — Mon, 19 Jun 2017 11:50:15 GMT

Try adding parenthesis to your search

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

Re: Listbox Selections

braham — Mon, 19 Jun 2017 11:55:57 GMT

Thanks Manish, putting it in brackets works.

Re: Listbox Selections

MK_QSL — Mon, 19 Jun 2017 11:57:14 GMT

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

Re: Listbox Selections

sunny_talwar — Mon, 19 Jun 2017 11:58:19 GMT