Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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
Partner

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
Partner

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

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
Partner

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
Partner

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
Partner

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