topic Re: Filter based on substring in field in App Development

Filter based on substring in field

josh_bee — Sat, 16 Nov 2024 18:42:06 GMT

Hi,

I'm building an app to show feedback according to particular themes, where each piece of feedback is assigned one or multiple themes.

Is there a way to have a master dimension with the possible theme values, and use a substring search on the field(or another method) to show any comment that has been tagged with the selected value/s?

Example structure is a table with:

observation | themes

"comment 1" | ['Leadership', 'Culture']

"comment 2" | ['Leadership', 'ICT', 'Policies/Processes']

"comment 3" | ['Leadership']

Is there a way to use a filter box:

- Leadership

- Culture

- ICT

- Policies/Processes

Such that if Leadership was chosen, all three would show, if ICT and Culture then comments 1 and 2, Culture comment 1 etc?

The data is currently tagged with a list of themes in python before being imported into Qlik.

Thanks for your help

Re: Filter based on substring in field

Taoufiq_Zarra — Mon, 04 May 2020 15:12:06 GMT

yes you can get these results in the load script using Subfield

for example :

output :

Re: Filter based on substring in field

josh_bee — Sun, 10 May 2020 23:16:05 GMT

Thanks for the suggestion Taoufiq, it's definitely a lot closer.

This generates a list of subthemes and duplicate records for each of the observations, however, as a result, the additive filtering doesn't work. E.g. if you select two subthemes, the filter returns the entire set instead of just the intersection.

Any ideas for a workaround?

Re: Filter based on substring in field

Taoufiq_Zarra — Mon, 11 May 2020 23:50:12 GMT

Can you give me some examples ?

are you ok for an UI solution instead of the script solution ?