Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ksharpes
Creator
Creator

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
treysmithdev
Partner Ambassador
Partner Ambassador

My favorite extension for this functionality is SimpleFieldSelect.

Blog: WhereClause   Twitter: @treysmithdev
ksharpes
Creator
Creator
Author

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?