Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
uridiumabs
Partner - Contributor II
Partner - 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
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

9 Replies
Anonymous
Not applicable

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

Anonymous
Not applicable

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.

jagan
Luminary Alumni
Luminary Alumni

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.

reddy-s
Master II
Master II

Hi Juan,

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

Thanks,

Sangram.

simondachstr
Luminary Alumni
Luminary Alumni

And the extension would use a bookmark Sangram.

reddy-s
Master II
Master II

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

Hi,

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

Regars,

Venelin 

simondachstr
Luminary Alumni
Luminary Alumni

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.

Anonymous
Not applicable

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.