Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
ksharpes
New Contributor III

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
Highlighted
Luminary
Luminary

Re: Wildcard as Variable for Input box / Set Analysis

My favorite extension for this functionality is SimpleFieldSelect.

Blog: WhereClause   Twitter: @treysmithdev
Highlighted
ksharpes
New Contributor III

Re: Wildcard as Variable for Input box / Set Analysis

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?