Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

List box -- filtering out data values to display

Hi everyone,

I'm an extremely new Qlikview user, so my question has essentially two parts.  I have a table that shows values associated to "Campaign_Name" and a list box that contains ALL of the available fields from "Campaign_Name", though I do not want to have them all there -- there is a bunch I want to filter out.

Basically what I want to do is show (in the list box and table) ONLY "Campaign_Name" values that contain "EVNT" AND "2012".  I am absolutely clueless as to how to filter this out.  Is this where I write an expression?  What would the syntax look like for this?

Second part of my question -- is there a handy reference guide that can give me some 101 on how to do things like this in the future?  The most confusing thing to me about Qlikview is by far crazy syntax/formulas to do these types of things.

ALL help is appreciated!

1 Reply
Not applicable
Author

You could use an expression I suppose.

this would probably work

IF(Campain_Name like '*2012*' or Campaign_Name like '*EVNT*', Campaign_Name)

However is there another field in the table that identifies these specific Campaign_Name values?