7 Replies Latest reply: Oct 27, 2017 6:08 AM by Onno van Knotsenburg

How to combine an exclusion and a list of selected terms in the same dimension?

Sinziana Lelescu Oct 24, 2017 1:54 PM

I'm fairly new to Qlik Sense and I'm just getting the hang of it. And I need to select a list of company names and exclude a company name when creating different charts for example bar chart or any other chart.

I created the following expression to select the company names and it works:

= If(WildMatch(ORG_NAME, 'K', 'F', 'M', 'Mo', 'Ge', 'Gu', 'in'), ORG_NAME, Null())

But how do I set an exclusion in the same expression? For example - "K Food"? So I want to select all the companies above and exclude "K Food".

I tried the following expression but it doesn't exclude "K Food":

=If(WildMatch(ORG_NAME, '*K*', -'K Food','F', 'M', 'Mo', 'Ge', 'Gu', 'in'), ORG_NAME, Null())

Thanks,

Re: How to combine an exclusion and a list of selected terms in the same dimension?

Sunny Talwar Oct 24, 2017 2:27 PM (in response to Sinziana Lelescu )

May be this

=If(WildMatch(ORG_NAME, '*K*', '*F*', '*M*', '*Mo*', '*Ge*', '*Gu*', '*in*') and not ORG_NAME LIKE 'K Food', ORG_NAME, Null())
Like Show 2 Likes (2)

Actions
- Re: How to combine an exclusion and a list of selected terms in the same dimension?
  
  Sinziana Lelescu Oct 24, 2017 2:43 PM (in response to Sunny Talwar )
  
  Thank you, the syntax is ok but the "K Food" still appears in the list somehow. I will try slightly different version because we are on the right track
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: How to combine an exclusion and a list of selected terms in the same dimension?
    
    Sunny Talwar Oct 24, 2017 2:55 PM (in response to Sinziana Lelescu )
    
    QlikView is case sensitive... are you sure the field is called K Food or is it K FOOD? Also, make sure that there is a space between K and F, not any other special character. May be try this
    
    =If(WildMatch(ORG_NAME, '*K*', '*F*', '*M*', '*Mo*', '*Ge*', '*Gu*', '*in*') and not UPPER(ORG_NAME) LIKE 'K*FOOD', ORG_NAME, Null())
    
    Like Show 1 Like (1)
    
    Actions
    - Re: How to combine an exclusion and a list of selected terms in the same dimension?
      
      Sinziana Lelescu Oct 25, 2017 10:42 AM (in response to Sunny Talwar )
      
      Thank you I was wondering is Qlik is case sensitive or not and now I know.
      
      Like Show 0 Likes (0)
      
      Actions
      - Re: How to combine an exclusion and a list of selected terms in the same dimension?
        
        Sunny Talwar Oct 25, 2017 3:30 PM (in response to Sinziana Lelescu )
        
        Did it work then?
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: How to combine an exclusion and a list of selected terms in the same dimension?
        
        Sinziana Lelescu Oct 27, 2017 6:02 AM (in response to Sunny Talwar )
        
        Yes it worked. Thanks
        
        Like Show 0 Likes (0)
        
        Actions
        
        Re: How to combine an exclusion and a list of selected terms in the same dimension?
        
        Onno van Knotsenburg Oct 27, 2017 6:08 AM (in response to Sinziana Lelescu )
        
        If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).
        If not, please make clear what part of this topic you still need help with .
        
        Like Show 0 Likes (0)
        
        Actions

Go to original post