Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Listbox

HI i have a field name [tp IASS] which has value if  aa,ab,ac,ad ,  i only want to show Aa,ac,and,ad.  in listbox

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

Re: Listbox

Try like

= IF(Not Match([tp IASS], 'ab'), [tp IASS])

View solution in original post

2 Replies
Highlighted
Champion
Champion

Re: Listbox

Hi,

try this:

=if(match(field,'value1','value2','value3',..'valuex'), field)

Highlighted
Champion III
Champion III

Re: Listbox

Try like

= IF(Not Match([tp IASS], 'ab'), [tp IASS])

View solution in original post