Matching character

[#1]

Hi,

I have a field customer which includes list of values are (INDIA ID, AUSTRIA CD, SRILANKA ID, SRILANKA CD, BRAZIL, FRANCE). I want to create a filter to get only ID and CD values.

Customer like '%ID or %CD.

If I use this filter Business users should able to see only (INDIA ID, AUSTRIA CD, SRILANKA ID, SRILANKA CD). these values

They should not see BRAZIL and FRANCE values.

How I can implement this in QlikView formula.

Thanks,

[#2]

Yes Tim,

I am using QV 9.0 SR5.

[#3]

HI Tim,

Sorry but I have no idea in QV 8.2. I had started using 9.0

Anyway, since your using a multi box, I assume that your gonna use it for filter. One solution you can do is filter it in the loadscript.

LOAD
 if(wildmatch(Customer,'* CD', '* ID'), Customer) as FilteredCustomer
FROM SampleTable

Let me know if this one helps.

Regards,

Nadsky

[#4]

Thanks, but I would like implement it in multibox.

Has any one come across the same scenario?

Thanks,