if statement help

[#1]

I am trying to show only certain fields in a listbox. i created a simple if statement in the 'expression' field within my listbox for 1 field and it worked great however i am having a hard time figuring out how to add a 2nd field so that my list box now shows only those 2 fields. any help would be greatly appreciated!!!

here is my 1 field expression: but if i want it to show both Canada and the US then how do i write that?

= if([Sales Office Name] ='Canada', [Sales Office Name])

-qlikview newbie

[nilesh_gangurde]

use the below expression

= if([Sales Office Name] ='Canada' or [Sales Office Name] = 'Value2' , [Sales Office Name])

OR

=if(wildmatch([Sales Office Name] ,'Canada' ,'Value2' ), [Sales Office Name])

-Nilesh

[#3]

wow thank you so much! i tried every other way to do an or statement but that way. i really appreciate it!

[nilesh_gangurde · Accepted solution]

If your Question is answered copmletly and correclty then please mark the post as correct ans or Helpful ans...

-Nilesh