topic Re: Selecting records using an input box in QlikView

Selecting records using an input box

fcecconi — Mon, 30 Mar 2015 18:11:36 GMT

Hello

I would like to select multiple records in a table by using an input box. I am able to select a single record, but not multiple.

I am taking my records from an excel spreadsheet and cutting and pasting into the input box. I have tried both a | as well as a , as delimiters.

I am using a button to Select in Field.

What am I doing wrong?

Re: Selecting records using an input box

Anonymous — Mon, 30 Mar 2015 18:16:49 GMT

Delimiter | is correct, and don't forget the parenthesis:

(value1|value2|value3)

Re: Selecting records using an input box

maxgro — Mon, 30 Mar 2015 18:29:47 GMT

and, if I'm not wrong, with space

("value 1"|"value 2"|"value 3")

Re: Selecting records using an input box

Anonymous — Mon, 30 Mar 2015 19:16:12 GMT

You're certainly not wrong. It is safe to use "" every time if there is a possibility of a space.

Re: Selecting records using an input box

fcecconi — Mon, 30 Mar 2015 19:19:26 GMT

Thanks everyone. I was able to get it to work. I added a | in the excel data. I then cut and pasted the data into the input box. On the button I added '('& variable &')' to the Select in Field value

thanks again!