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]

Hi Tims,

You can try using wildmatch

</h2><h2>wildmatch(Customer, '* ID', '* CD') </h2><h2>

Regards,

Nadsky

[#3]

Thanks, In Multitab I couldn't find the expression tab, where I have made this formula..

Thanks,

[#4]

HI Tims,

Please see attached file. The 2nd list box uses wildmatch.

Hope this one helps.

Regards,

Nadsky

[#5]

I am unable to download, pls don't mind can share the formula.

Thanks,

[#6]

Hi Tims,

Here's the formula I've used:

=if(wildmatch(Customer,'* CD', '* ID'), Customer)

Any questions let me know.

[#7]

Thanks Nad for the formula but in multibox dashboard where I have to define this formula, because I couldn't find any expression tab in multibox.

Pls let me know..

Thanks,

[#8]

HI Tim,

Check this image. Use the Expression button (see encircled part of the image)

BTW, Im using QlikView V9 SR4

Regards,

Nadsky

[#9]

Hi,

You can use the calculated field in multibox using expression as highlighted in above image.

[#10]

Thanks for the screen shot, but its not there in Version 8.2, I guess you people are using Higher versions.

Any ideas in 8.2?

Thanks,