Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Showing results for 
Search instead for 
Did you mean: 

Wildcard as Variable for Input box / Set Analysis

I have a variable called v_CoverageGroup set to ''Short', 'Med', 'Long', 'Very Long'' by default.

This shows all of the desired selections for a set analysis I have done.

I have an input box so I can select each of the selections one at a time however I cannot put ''Short', 'Med', 'Long', 'Very Long'' as an option as it refuses to accept the syntax.

to get around this is there a way to have a selection use the default value? or perhaps a way of clearing the selections instead?

OK well it appears my Default variable does not seem to working correctly either, Would it be possible to have a wildcard instead and show all values?

2 Replies
Luminary Alumni
Luminary Alumni

My favorite extension for this functionality is SimpleFieldSelect.

Blog: WhereClause   Twitter: @treysmithdev

Thanks, although that doesn't get over the issue I'm having 

My Code is as follows:Sum({<[Reporting Date]={'$(=monthend(MAX([Reporting Date]),-6))'},[Coverage Group (All)]= {'$(=v_CoverageGroup)'}>}[Stock Value €])


My Variable (v_CoverageGroup) has values of Short, Med, Long & Very Long

How can create a variable that has all four values that still works?