topic Re: Filter cells that contain partial value...Wildcard? in QlikView

Filter cells that contain partial value...Wildcard?

Wed, 06 May 2015 03:26:20 GMT

Hello,

I am trying to figure out how to filter items in one table and how the second table return any cells that contain all of the filtered selections.

Example:

Field 1 and Field 2 are actually unrelated tables but if you select from Field 1 then Field 2 should filter results based on Field 1. If having the two tables not linked is a bad way to go please help me figure out the right way:)

Field 1

Dogs

Has

Super

Town

Field 2

Dogs Town

Has Dogs

Super Town

Super Town Has Dogs

Town Dogs

Answer: 1 because the two items selected in Field 1 appear only once in the same cell in Field 2 (order of how Field 1 results display in Field 2 should not matter).

I'm hoping someone can actually add a formula or whatever is needed to help me get the necessary results. I've attached a test file that you can tweak.

Thanks so much.

Barb

Re: Filter cells that contain partial value...Wildcard?

PrashantSangle — Wed, 06 May 2015 04:50:36 GMT

Hi,

I dont think so with out association there is any way to acheive required output in front end,

but

You can try with this logic create releation between those two table by using exist() and not exist() in script.

Regards

Re: Filter cells that contain partial value...Wildcard?

marcus_sommer — Wed, 06 May 2015 10:14:40 GMT

You could with a concat on Field 1 feed a match/wildmatch-filter on the Field 2 listbox - see the attachment.

- Marcus

Re: Filter cells that contain partial value...Wildcard?

Wed, 06 May 2015 13:56:00 GMT

This works however this is for external clients to use so it really needs to be more UI geared. There needs to be a way to make it dummy proof because our clients aren't Qlik experts. They will basically just want to click filters to get the final results that they're looking for.

If Field 1 and Field 2 have to be linked I think that's okay but I'm not sure how best to set this up.

Thanks for your input, Marcus.

Re: Filter cells that contain partial value...Wildcard?

marcus_sommer — Wed, 06 May 2015 14:04:57 GMT

Normally the user don't get in touch with these filter-expression if they is once defined and applied. But if you could find a logic to link these data within the datamodel it will be better.

- Marcus