Discussion board where members can get started with QlikView.
I am trying to exclude data that contains the word 'Proposed - ' in it. for instance the values are as follows.
I was able to hide specific TopicArea2 using Where IsNull(ows_TopicArea) or Not Match(ows_TopicArea,'71;#PROPOSED - Capital Requirements of SDs') (http://community.qlik.com/message/248036)
Thank you for your time.
Is there a way to ignore all those TopicArea2 with 'PROPOSED -' listed in the titles instead of having the whole names listed?
Go to Solution.
You could look into the Wildmatch() function, so maybe try:
... Not Wildmatch(ows_TopicArea,'*PROPOSED*');