topic Re: Help I still new to Qlik... using the IF,not equal, notmatch expression in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

oscar_ortiz — Wed, 18 Oct 2017 19:57:50 GMT

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

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

Good luck

Oscar

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

Wed, 18 Oct 2017 20:13:20 GMT

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

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

oscar_ortiz — Wed, 18 Oct 2017 20:20:28 GMT

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

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

oscar_ortiz — Wed, 18 Oct 2017 20:22:18 GMT

Ambrose,

Maybe something like this:

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

Good luck

Oscar

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

Wed, 18 Oct 2017 20:51:51 GMT

Cheers Oscar!

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

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

oscar_ortiz — Wed, 18 Oct 2017 21:46:52 GMT

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