Discussion board where members can get started with Qlik Sense.
In our report we have a selector box in front end dashboard and filter source having having two values as:-
I need to create a third value as 'ALL'(Order+Backorder), so that user should be able to select this 'ALL' from the drop down.
so now it should be:-
Please suggest how can I achieve this.
you can add in your script as below:
'Order' as current_field
'Order' as new_field
'Backorder' as current_field
'Backorder' as new_field
Order' as current_field
'ALL' as new_field
in the UI use new_field as filter.
Thanks for your response.
I tried to implement this, but how can we link this table with our fact table, as source field is from the fact table.
Because if I check in data model , there is no link between link and fact table.
Add new values in listbox for filtering | Qlik Community
you have to rename new_field as your fact table field.
But for what? If there is nothing select in filter you already get Order+Backorder...
By default 'Order' value should be selected.
If I set' Order' as default value then 'ALL' filter is not working.
It allows to select the 'ALL' from the drop down, but the same time it's reflecting back to Order data.