Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to set a default value for a filter?

Hi,

I have a region filter with values ALL, North, South, East and West. I want the default value to be ALL when I open the app, and also be able to make different selections later on. When the app first loads, the values in the visualizations should be for ALL filter value by default.

How can I achieve this?

Thanks,

Srijhari

12 Replies
oknotsen
Honored Contributor III

Re: How to set a default value for a filter?

Moved your topic to New to QlikView as it was posted in an unrelated forum and here there is at least a 50% chance it is related.

If this, however, was intended as a Qlik Sense question, please let me know and we move it there.

May you live in interesting times!
Not applicable

Re: How to set a default value for a filter?

Hi,

Sorry about that. I was referring to Qlik Sense actually.

Thanks for the help.

mark6505
Valued Contributor III

Re: How to set a default value for a filter?

Hi,

Settings > Document properties > Triggers.

Document Event triggers > OnOpen.

Select Add actions, Add

In selection chose select in field.

Add your field name Region and value ALL.

Mark

Not applicable

Re: How to set a default value for a filter?

Hi,

Where can I find the settings? I am using Qlik Sense Desktop.

Re: How to set a default value for a filter?

There should be no need to pre-select ALL as in QlikView, when nothing is selected, then all values are included by default.

This is indicated by the Green, White, Grey colours - Green is what you have actively selected, Grey is what is excluded by your selection, and white are values associated with the selected values.

There are a couple of blogs that describe the association between selected data here

Green Is the Colour

Qlik Tips: Raise a flag to the Green, White and Gray

Re: How to set a default value for a filter?

You could use the ON Open trigger on that field . try like this

Go to document Properties > Triggers >On Open> Add Action> select the field and value

Not applicable

Re: How to set a default value for a filter?

Hi Colin,

Thanks for providing the resources. Is there a way I can control the interactions between sheets of the same app?

Thanks!

Not applicable

Re: How to set a default value for a filter?

Hi Avinash,

I don't see document properties in Qlik Sense?

oknotsen
Honored Contributor III

Re: How to set a default value for a filter?

Topic moved to New to Qlik Sense.

May you live in interesting times!