topic Re: List Box Used to Filter a Column with Mulitple Variables in QlikView

List Box Used to Filter a Column with Mulitple Variables

Fri, 25 Apr 2014 13:34:43 GMT

I have a list box with a list of different products / services offered by my company as such:

Product1

Product2

Product3

Product4

Product5

Then I also have a straight table that includes details about projects related to these different products, which some can have multiple products included.

What I am tryiing to do is when I select Product1 in the list box, I want the straight table to filter those projects in which include Product1.

Re: List Box Used to Filter a Column with Mulitple Variables

Fri, 25 Apr 2014 13:40:32 GMT

If your tables with projects and products are associated, you will get it in standard

Re: List Box Used to Filter a Column with Mulitple Variables

Fri, 25 Apr 2014 14:42:35 GMT

The list box and table variable is Product, however when I click on Product1 in the list box, it doesn't bring up anything. I think it's because the Product field in the table shows Product1;Product2;Product3 if there are multiple Products assigned to a project.

Re: List Box Used to Filter a Column with Mulitple Variables

rustyfishbones — Fri, 25 Apr 2014 14:48:59 GMT

use

SUBFIELD(Product,';',) as Product

and then try

Re: List Box Used to Filter a Column with Mulitple Variables

Fri, 25 Apr 2014 15:36:42 GMT

The problem with that if I do that the project in the table is duplicated if it has multiple Products.....can the list box somehow search like a CONTAINS statement...so for all projects that CONTAINS Product1, return it?

Re: List Box Used to Filter a Column with Mulitple Variables

rustyfishbones — Fri, 25 Apr 2014 15:40:28 GMT

Can you post a sample or even an image of what the list box looks like currently

Regards

Alan

Re: List Box Used to Filter a Column with Mulitple Variables

Fri, 25 Apr 2014 15:41:05 GMT

Chris,

Please share your application with sample data.

Regards

Darek

25-04-2014 17:37 użytkownik "Chris Giermann" <qcwebmaster@qlik.com>

napisał:

Qlik Community <http://community.qlik.com/> List Box Used to
Filter a Column with Mulitple Variables
reply from Chris Giermann<http://community.qlik.com/people/cgiermann?et=watches.email.thread>in *Layout
& Visualizations* - View the full discussion<http://community.qlik.com/message/516365?et=watches.email.thread#516365>

Re: List Box Used to Filter a Column with Mulitple Variables

Fri, 25 Apr 2014 15:47:15 GMT

Here is what I am trying to do and I have protected all sensitive information so the blackout portions are other columns giving details about specific projects. So what I want to do is select 'Deposits' from the list box and have all three of these records still appear. Then I want to select 'Home Equity' and the middle record disappears. I have alot of projects that affect multiple products so I want the end user to only focus on their Product line.

Re: List Box Used to Filter a Column with Mulitple Variables

rustyfishbones — Fri, 25 Apr 2014 16:01:38 GMT

ok instead of a list box, you can use buttons and use select in field

Also add a clear all selection as the first Action and then add the Select in Field

See the attached

Regards

Alan

Re: Re: List Box Used to Filter a Column with Mulitple Variables

rustyfishbones — Fri, 25 Apr 2014 16:02:35 GMT

Apologies

See attached

Re: Re: List Box Used to Filter a Column with Mulitple Variables

Fri, 25 Apr 2014 16:28:46 GMT

Thank you, the buttons worked great!