topic Re: if statement help in QlikView

if statement help

Wed, 01 May 2013 18:15:06 GMT

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

Re: if statement help

nilesh_gangurde — Wed, 01 May 2013 18:18:33 GMT

use the below expression

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

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

-Nilesh

Re: if statement help

Wed, 01 May 2013 18:23:15 GMT

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

Re: if statement help

nilesh_gangurde — Wed, 01 May 2013 18:33:34 GMT

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

-Nilesh