Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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?