I have a list box in QlikView that has an order status field. It had three values: Open, Posted and Deleted. I had a situation in QlikView where when the document opens I wanted to select Open and Posted, but not Deleted. Someone suggested that I use Open|Posted in the search string. Unfortunately, that didn’t work. I searched and searched and found plenty of different ways suggesting to do it and none worked except for using a macro. I didn’t want to use a macro and I knew there had to be a way. I finally found this post on the Qlik community with the correct answer. The answer is to use the value “(OPEN|POSTED)” (without the quote). I used this on a button to test and the action looks like the below.
Hopefully this helps someone!
About the Author:
TopLine Strategies delivers the complete integration and development of sales, marketing and customer service technologies that enable corporate clientele to improve revenue streams and strengthen customer interactions. Our project management and consulting is designed to achieve timely delivery, 100 percent user adoption of the technologies we implement and deliver measurable returns on investments for our clients.