Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
you may want to use bookmark feature, make the selection first, then save a to bookmark. that's simple.
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.
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.
Hi Juan,
For complex initial selections, if needed you can go with an extension to achieve this.
Thanks,
Sangram.
And the extension would use a bookmark Sangram.
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.
Hi,
You can use from Document Properties - Triggers. There are a lot of options for selection on specific field/s.
Regars,
Venelin
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.
Just came across this QlikSense extension on Qlik Branch: applySelections
Could be just what you are after :
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.