Can't Filter string correctly From List Box.

[#1]

Hi,

   I am Trying to Filter values from my list box and the values are filtered only based on first string that is matched from list of values in Straight table. Suppose if there are list of values separated by commas {Brand, Client, Product} and I am using a list box to filter them out when I click on Brand, I should get all the rows that contain "Brand" but I am getting only the rows that starts with Brand.  I was figuring out how do we use contains in qlikview, like how we use in Excel. Please take a look at my QVW attachment and your answer is very Precious to me.

Thanks,

Srihari.

[swuehl · Accepted solution]

Do something like

LOAD ID,

          Trim(Subfield(Error_Fields, ',')) as SingleError

RESIDENT YourTable;

Then create a SingleError list box

edit:

attached a sample, also trim()

[#3]

Thanks For your Answer, It Worked.