Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shikhakumari18
Contributor

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

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.

7 Replies
agigliotti
Honored Contributor II

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

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.

shikhakumari18
Contributor

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

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
Contributor III

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

agigliotti
Honored Contributor II

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

you have to rename new_field as your fact table field.

vasiliy_beshent
Contributor III

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

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

shikhakumari18
Contributor

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

Hi Vasiliy,

By default 'Order' value should be selected.

shikhakumari18
Contributor

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

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.

Community Browser