Clear all except one field in Qlik Sense

[Qlik1_User1]

Hi All,

Need one help, is it possible to clear all fields in dashboard expect one field(Country) when clicking on clear all( present on top left corner).

Scenario:

Let says user select fields like City,Country,state and when user  clicks on clear all. All selections made on fields except Country should be remove but no selections should be removed from country field.

Not to use:

Button in Dashboard Bundle.,Always one selected

Please suggest.

[sebastiandperei]

Hi! 

The solution should me functional plus technical. Pleas, tell me, why you can't use a Button or Always one Selected?

[NitinK7]

Hi,

1. go to filed at left hand side 

2.select country and right click on country

3.got to field settings

4. check always one selected values.

see below  below screenshot

Thanks,

Nitin.

[Qlik1_User1]

@sebastiandperei 

Always one selected value cant be used because when dashboard opens it will default to the first value of a field..but we don't need that.

We can use buttons but object overlaps is not possible in Qliksense as we have in Qlikview. Hence cant use buttons.

[Qlik1_User1]

Thanks but can't use Always one value selected.

[NitinK7]

I think it is might be not possible 

[sebastiandperei]

Hi! With QS Feb2020 version you got actions...

But, else, you could make another field that groups all the country values. Add the following at the end of script:

country_group:
load distinct
    [country field],
    [country field] as [country new field]
resident Table_with_country_field;
concatenate (country_group)
load distinct
    [country field],
    'Total' as [country new field]
resident country_group;

Now, if you put "always one selected value" with [country new field] you could select "Total", with all the possible values of [country field]