Help I still new to Qlik... using the IF,not equal, notmatch expression

[#1]

Hi guys,

So I have a table. In "Column 1", I have a range of names for example, Vera Manning, Curtis Daniels, Holly Howell.

In "Column 2", I  have numbers ranging from 1-10000$.

What I want to do is to colour both columns IF "Column 2">5000 AND "Column 1" (IS not Vera Manning), Red ())

So essentially, anything that is over 5000 AND does not have Vera Manning's name in Column 1 , I want the entire (e.g. Curtis Daniels and amount of 6000) row to be highlighted red if possible. If not, at least the amount is highlighted.

How do I do it?

Thanks

Yours sincerely,

Ambrose Lau

[oscar_ortiz · Accepted solution]

Try something like this for your background color in your chart.

If( Column1 <> 'Vera Manning' and Column2 > 5000, Red() )

Good luck

Oscar

[#3]

Thanks it helps! Another issue I have, In Column 1, I have a range of names. In Column 2, I have a range of numbers

What I want to do is IF (Column 1 <> 'Vera  Manning, Curtis Daniels, Holly Howell' , Red () )
So essentially, if the names are not Vera Manning, Curtis Daniels or Holly Howell. I want to make the any other names or numbers red.

Yours sincerely,

Ambrose Lau

[oscar_ortiz]

Ambrose,

Not sure if you solved your issue.  But if you have would you mind closing the thread.

Qlik Community Tip: Marking Replies as Correct or Helpful

Thanks

Oscar

[oscar_ortiz]

Ambrose,

Maybe something like this:

If( Not WildMatch( Column1, 'Vera Manning', 'Curtis Daniels', 'etc' ) , Red() )

Good luck

Oscar

[#6]

Cheers Oscar!

In addition, I have around 100 names so how can I display only the highlighted ones from a pivot table?

[oscar_ortiz]

Ambrose,

In a situation like that I would do something with the data itself.  Create a flag field with a value of 1 for all the names that you want on your list.  Hopefully, you can do that programmatically.

Then just check for the value of that new flagged field.

Good luck

Oscar