Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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)