How to add a third value as 'ALL' in filter box

[abc_18]

Hi,

In our report we have a selector box in front end dashboard and filter source having having two values as:-

Order

Backorder

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:-

Order

Backorder

ALL

Please suggest how can I achieve this.

[agigliotti]

you can add in your script as below:

link_table:

load

     'Order' as current_field

     'Order' as new_field

Autogenerate 1;

load

     'Backorder' as current_field

     'Backorder' as new_field

Autogenerate 1;

load

     Order' as current_field

     'ALL' as new_field

Autogenerate 1;

load

     'Backorder' as current_field

     'ALL' as new_field

Autogenerate 1;

in the UI use new_field as filter.

[abc_18]

Hi Andrea,

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.

[ChennaiahNallani]

Try this

Add new values in listbox for filtering | Qlik Community

[agigliotti]

you have to rename new_field as your fact table field.

[Vasiliy_Beshentsev]

But for what? If there is nothing select in filter you already get Order+Backorder...

[abc_18]

Hi Vasiliy,

By default 'Order' value should be selected.

[abc_18]

Hi Andrea,

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.