Exclude data from a field.

Thu, 11 Oct 2012 18:06:40 GMT

Hi,

I am trying to exclude data that contains the word 'Proposed - ' in it. for instance the values are as follows.

TopicArea2
66;#Amendments to CPO Regulations
67;#Swap Transaction and Implementation Schedule:
68;#PROPOSED - Adaptation of Regulations to Incorporate Swaps
69;#PROPOSED - Agg, Position Limits for Futures and Swaps
70;#PROPOSED - Anti Practices Authority
71;#PROPOSED - Capital Requirements of SDs
66;#Amendments to CP and CT Regulation
67;#Swap Transaction Compliance and Implementation Schedule
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?

Re: Exclude data from a field.

swuehl — Thu, 11 Oct 2012 18:10:00 GMT

You could look into the Wildmatch() function, so maybe try:

... Not Wildmatch(ows_TopicArea,'*PROPOSED*');

Re: Exclude data from a field.

Thu, 11 Oct 2012 19:59:41 GMT

Thank you.

topic Re: Exclude data from a field. in QlikView

Exclude data from a field.

Re: Exclude data from a field.

Re: Exclude data from a field.