Multiple QlikView Select in Field String Values

Printer-friendly version

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.

Comments (0)

Related Blogs

TheReact Native Open Source roadmap was announced in Q4 2018 after they decided to invest more in the React Native open source community.

October is not just about pumpkins, fall foliage, and cooler temps anymore. October 2018 also means the exciting introduction of Microsoft Dynamics 365 for Customer Engagement.

Back in 2016, Microsoft introduced its intentions to refresh its CRM and ERP strategy with Dynamics 365. At the heart of its services was the Common Data Model (CDM).