Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Creator III
Creator III

Clear all except one field in Qlik Sense

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.

6 Replies
sebastiandperei
Specialist
Specialist

Hi! 

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

NitinK7
Specialist
Specialist

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

one select.PNG

Thanks,

Nitin.

Qlik1_User1
Creator III
Creator III
Author

@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
Creator III
Creator III
Author

Thanks but can't use Always one value selected.

NitinK7
Specialist
Specialist

I think it is might be not possible 

sebastiandperei
Specialist
Specialist

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]