topic Re: Limited filter box values in QlikView

Limited filter box values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a column "Category" and there are many values. I would like to have them limited to be viewed in my filter box to those that starts with "Sales". What is the way to get it?

Maciej

Re: Limited filter box values

jpenuliar — Tue, 22 Nov 2016 15:02:56 GMT

Hi Maciej,

you can add a new field (in Script) like below:

If(Wildmatch(Category),'*Sales*',Category,'Others') as AnotherCategory

Re: Limited filter box values

Anonymous — Mon, 28 Nov 2016 15:35:49 GMT

Hi Jonathan,

I apologise for a long time to give you feedback. It works, thanks for your help. I only had to made some impovementst because ther was little mistake in the code. It should look like this:

if(Wildmatch(Category,'Sales*'),Category,'Others') as AnotherCategory.

Can I get on the filter list only those 'Sales*' without Others? The data in my visualization only refers to the Sales and there won't be no others.?

Re: Limited filter box values

Anil_Babu_Samineni — Mon, 28 Nov 2016 15:54:23 GMT

May be this to show only sales data

if(Wildmatch(Category,'Sales*'),Category) as field

Re: Limited filter box values

Anonymous — Mon, 28 Nov 2016 21:22:46 GMT

You're right Anil, thanks. 🙂

Re: Limited filter box values

MarcoWedel — Mon, 28 Nov 2016 21:32:34 GMT

Hi,

maybe one solution could be:

hope this helps

regards

Marco

Re: Limited filter box values

Anonymous — Tue, 29 Nov 2016 10:34:19 GMT

I've checked it and it also works fine and it's very nice. Thank you Marco :-).