Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

uridiumabs
New Contributor II

Automatic selection in Qlik Sense

Hi,

I want to filter my sheet automaticaly when the App is opened for the first time.

Tipically selecting the current year for instance.

Is this possible?

Thank you very much.

1 Solution

Accepted Solutions
MVP
MVP

Re: Automatic selection in Qlik Sense

Hi,

Add a flag for current year and bookmark it.

DAta:

LOAD

*,

If(Year(DateFieldName) = Year(Today()), 1, 0) AS CurrentYearFlag

FROM DataSource;

Now Select 1 in CurrentYearFlag and bookmark and then save your app.

Regards,

jagan.

9 Replies
double7671
Contributor

Re: Automatic selection in Qlik Sense

you may want to use bookmark feature, make the selection first, then save a to bookmark. that's simple.

nakul1001
Contributor II

Re: Automatic selection in Qlik Sense

Having a bookmark is the way to go about it. I understand you would preferably want it automatic such than when Yr changes, the selection is updated as well (as opposed to a bookmark where it will be static). In QlikSense there is no on-open document trigger option readily available so this might require use of API.

MVP
MVP

Re: Automatic selection in Qlik Sense

Hi,

Add a flag for current year and bookmark it.

DAta:

LOAD

*,

If(Year(DateFieldName) = Year(Today()), 1, 0) AS CurrentYearFlag

FROM DataSource;

Now Select 1 in CurrentYearFlag and bookmark and then save your app.

Regards,

jagan.

reddys310
Honored Contributor II

Re: Automatic selection in Qlik Sense

Hi Juan,

For complex initial selections, if needed you can go with an extension to achieve this.

Thanks,

Sangram.

Luminary
Luminary

Re: Automatic selection in Qlik Sense

And the extension would use a bookmark Sangram.

reddys310
Honored Contributor II

Re: Automatic selection in Qlik Sense

Hi Martin,

You can even have an expression to select the value you need Martin. Make an initial selection using Javascript in the extension.

Thanks,

Sangram.

venelin_rs
New Contributor III

Re: Automatic selection in Qlik Sense

Hi,

You can use from Document Properties - Triggers. There are a lot of options for selection on specific field/s.

Regars,

Venelin 

Luminary
Luminary

Re: Automatic selection in Qlik Sense

Yes, if you know the initial selection and if your field names remain static. If you need something more generic, where you transfer the whole set of applied filters, you will need to use bookmarks.

Re: Automatic selection in Qlik Sense

Just came across this QlikSense extension on Qlik Branch: applySelections

Could be just what you are after :

applySelections

Automatically apply bookmark based on the user that opens the sheet. This extension can be useful if you want something that emulates the "on sheet opening" actions of qlikview.

Community Browser