I want to create a multi-value picklist filter with each value has its own unique logic.
in the main table that filter will apply, I create attributes for filter1, filter2, filter3 using IF statement,
and then, I create a filter table using inline:
Load *inline [
Pickname, filter1, filter2, filter3
Pickname1, 'true', ,
for the inline table, I intent for qliksense to ignore attribute that does not have value specified. For example, for Pickname3 row, I want it to ignore filter1, and filter2 values regardless of 'true' or 'false', as long as filter3 has a value of 'true'. Somehow the syntax does not seem work. Also, please provide a better approach if there is one.
Pickname1 is "Next 30 Days", Pickname2 is "No End Date", for example. so the filter (depending on which user selects) will apply to a list table, and only those records that fulfill the criterion will show in the list table.
I actually find a work-around to allow qliksense to ignore certain filters by listing all possible values out in the inline table. The multi-value filter actually works now.
However, I doubt this is a smart solution as it is built on the assumption that only same values under the same column names could be used as filters, therefore multiple synthetic keys are generated during data load. Please provide an alternative approach.
I am trying to use buttons for navigation under visualization bundle to work around this. For example, one button for one value. It seems that I can only specify specific values, rather than define queries in the value field. Have I missed anything?