topic Re: Listbox which impacts a different field? in QlikView

Listbox which impacts a different field?

Wed, 08 Apr 2015 17:10:39 GMT

I have a situation where a given record may have multiple "Tags" associated with it. The tags are stored in a varchar(max) field in the database and each tag is comma separated. I also have a table of all possible tags.

What I need to do is give the users a listbox of the possible tags (a stand-alone table), and then use something on the other field which filters the data in a wildcard manner (LIKE)? So if the user selects Tag1 and Tag2 from the listbox. The actual data field may have values like "Tag1" for one record but "Tag7,Tag4,Tag2" in another. I need it to identify all records which have any of the relevant values anywhere in it and have that as the filter.

Can I have a listbox on one field but have the filter apply to a different field in a wildcard manner and the wildcard by dynamic depending on how many values they select?

Thanks.

Mark.

Re: Listbox which impacts a different field?

Anonymous — Wed, 08 Apr 2015 19:18:18 GMT

Mark,

Here is a way how to implement this. For example, you have a table named DATA that contains this field with comma-separated tags. Let's assume the field name is Tags. Create additional logical table:

LOAD DISTINCT
Tags,
trim(subfield(Tags,',')) as Tag
RESIDENT DATA;

Now, the field Tag contains all values, and selections in this field will return the result you need.

Regards,
Michael

Re: Listbox which impacts a different field?

Thu, 09 Apr 2015 14:52:00 GMT

Thanks Michael,

I currently have a separate table that has all the distinct tag values. However, using that field for a listbox does me no good as it does not filter the table which has the data I want.

The data I want to filter also has a Tags field but there the tags are a comma delimited string. What I need is to be able to select a tag from the listbox on the dimensional table, and have it effect the field on the data table. It also needs to be a "Like" match "Like '%Tag1%', '%Tag2%'", etc. Thus, if I select multiple items in the dimensional listbox, I'll need to create a match string that will dynamically be used to filter the main data set.

Regards,

Mark.

Re: Listbox which impacts a different field?

Anonymous — Fri, 10 Apr 2015 13:15:45 GMT

Mark,

I don't see a problem. You can do it all using that list box, no artificial complications needed. See attached.

Regards,

Michael

Re: Listbox which impacts a different field?

Fri, 10 Apr 2015 14:27:55 GMT

Sorry, I didn't understand the solution you were talking about as I read it initially. Seeing it in action confirms that will do exactly as I need.

Thank you.

Re: Listbox which impacts a different field?

Anonymous — Fri, 10 Apr 2015 14:44:16 GMT

Thanks for confirmation Mark. I thought one time maybe I got the requirements wrong...