Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Exclude data from a field.

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?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Exclude data from a field.

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

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

2 Replies
MVP
MVP

Re: Exclude data from a field.

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

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

Not applicable

Re: Exclude data from a field.

Thank you.

Community Browser