Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

multi-value picklist

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

 

 

Labels (1)
4 Replies
Highlighted
Luminary
Luminary

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

Blog: WhereClause   Twitter: @treysmithdev
Highlighted
Partner
Partner

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.

Highlighted
Partner
Partner

 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,

Highlighted
Partner
Partner

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?