New to Qlik Analytics

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

Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!

Who Me Too'd this topic

fabian3684386
Contributor III
Contributor III

Possibilities to include non-selected values in smart search with "Always one selected value"

Is it possible please in QlikSense to show a non-selected value within the SMART search for a field with this requirement:

*  always one selected value (e.g. set to A)

* When user searches for B, B should appear even though that selection is not possible because of the already "always one selected value" A.

* always one selected value cannot be turned off in my case because my extension parameter formula breaks otherwise, it looks like this:

 

 

 

=Coalesce(If((NOT GetCurrentSelections() = '') and (NOT GetFieldSelections(single_select_field) = '') and GetSelectedCount(single_select_field) = 1,
concat(
aggr(
	only([field_to_aggregate]),
	[field_to_aggregate]
),
'$'
),
'$' // else selection should be made prior to expensive aggr
), '$')
// Conditional aggregation breaks when no selection is made at all in no field and this expression is passed as an extension parameter within QlikSense on-prem (even though it is logically wrong then to fill with all data, all data is loaded and aggregated, so I figured I should leave "always one selected value" on, but now it breaks the smart search)

 

 

 

Qlik Sense Business 

 

Labels (2)
Who Me Too'd this topic