topic multi-value picklist in App Development

multi-value picklist

QSSR — Sat, 16 Nov 2024 18:57:30 GMT

Hello,

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', ,

Pickname2, ,'true',

Pickname3, ,,'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.

Thanks,

Gia

Re: multi-value picklist

treysmithdev — Wed, 11 Mar 2020 17:58:11 GMT

Can you provide an example of how you are later using the Pick list?

Re: multi-value picklist

QSSR — Wed, 11 Mar 2020 18:19:37 GMT

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.

Re: multi-value picklist

QSSR — Wed, 11 Mar 2020 21:46:50 GMT

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.

Thanks,

Re: multi-value picklist

QSSR — Thu, 12 Mar 2020 20:36:06 GMT

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?