topic Matching character in QlikView

Matching character

Thu, 23 Sep 2010 08:04:56 GMT

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,

Matching character

Thu, 23 Sep 2010 08:23:42 GMT

Hi Tims,

You can try using wildmatch

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

Regards,

Nadsky

Matching character

Thu, 23 Sep 2010 09:31:21 GMT

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

Thanks,

Matching character

Thu, 23 Sep 2010 09:41:02 GMT

HI Tims,

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

Hope this one helps.

Regards,

Nadsky

Matching character

Thu, 23 Sep 2010 10:41:16 GMT

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

Thanks,

Matching character

Thu, 23 Sep 2010 11:24:47 GMT

Hi Tims,

Here's the formula I've used:


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

Any questions let me know.

Matching character

Fri, 24 Sep 2010 06:29:52 GMT

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,

Matching character

Fri, 24 Sep 2010 07:03:51 GMT

HI Tim,

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

BTW, Im using QlikView V9 SR4

Regards,

Nadsky

Matching character

Fri, 24 Sep 2010 07:04:00 GMT

Hi,

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

Matching character

Fri, 24 Sep 2010 07:20:17 GMT

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,

Matching character

Fri, 24 Sep 2010 08:30:11 GMT

Yes Tim,

I am using QV 9.0 SR5.

Matching character

Fri, 24 Sep 2010 09:18:00 GMT

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

Matching character

Fri, 24 Sep 2010 11:34:09 GMT

Thanks, but I would like implement it in multibox.

Has any one come across the same scenario?

Thanks,