Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
yes you can get these results in the load script using Subfield
for example :
Data:
load subfield(themes,',') as Sub_Themes,rowNo() as ID,* inline [
observation | themes
"comment 1" | "Leadership, Culture"
"comment 2" | "Leadership, ICT, Policies/Processes"
"comment 3" | "Leadership"
](delimiter is '|') ;
output :
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?
Can you give me some examples ?
are you ok for an UI solution instead of the script solution ?