Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
oscar_ortiz
Partner - Specialist
Partner - Specialist

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

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

Good luck

Oscar

View solution in original post

6 Replies
oscar_ortiz
Partner - Specialist
Partner - Specialist

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

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

Good luck

Oscar

Not applicable
Author

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
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist

Ambrose,

Maybe something like this:

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

Good luck

Oscar

Not applicable
Author

Cheers Oscar!

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

oscar_ortiz
Partner - Specialist
Partner - Specialist

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