topic Input box: multiple text values in QlikView

Input box: multiple text values

Tue, 12 Jan 2016 08:33:26 GMT

I want to use an inbox to allow filtering of multiple text values (part numbers).

The records in my main table are sales records with date, part numbers, qty and price.

In the inputbox I want to enter e.g. 5 part numbers (comma seperated) and use these parts numbers (e.g. AB0001, AB 2012, CD0003, DF0999, RT50001) as a filter for the main table so the result will be that I onnly have sales date for the 5 parts numbers enterted in the input box.

Any suggestions?

Re: Input box: multiple text values

Chanty4u — Tue, 12 Jan 2016 09:36:06 GMT

hi,

https://community.qlik.com/message/326346#326346

https://community.qlik.com/message/208461#208461

hope this helps u

Re: Input box: multiple text values

miguelbraga — Tue, 12 Jan 2016 09:37:53 GMT

Hi Chris,

Can you please share a .qvw sample or a excel/qvd file so we can build a solution for you?

Regards,

Re: Input box: multiple text values

Tue, 12 Jan 2016 09:49:46 GMT

Attached is a example.

I want to enter in the inputbox multiple part values (comma seperated) to make a selection in the data table.

Thanks in advance,

Chris

Re: Input box: multiple text values

jonathandienst — Tue, 12 Jan 2016 10:12:42 GMT

Firstly, is this really necessary? If the part numbers are exposed in a list, then it is easy for the users to make the selections and there is no need for variables, buttons, actions etc.

But assuming you have a good reason, then you can add a variable and an input box for the user to enter a comma-separated list. Then link a Select in Field action to a button or text object and use an expression like $(='(' & Replace(vInputList, ',', '|') & ')') as the search expression.

Re: Input box: multiple text values

Wed, 13 Jan 2016 07:14:29 GMT

I have my reasons ... it worked thanks a lot!