Discussion board where members can get started with Qlik Sense.
I use Qlik sense desktop
I have in my dashboard a pivot table with one dimension = Date of the first day of week (104 weeks of 2015 and 2016).
When I open the dashboard I need to display the current week.
Is there any way to have a dynamic bookmark or dynamic filter when I open the sheet?
Thank you in advance
Go to Solution.
If you are willing to have a sheet to only display the current week, you can show current week using Set Analysis
Using function today () in set analysis?
Use the TODAY() function in conjunction with the WEEKSTART function to get data for the current week.
You could then have a second sheet with the same pivottable on it, but without the Set Analysis, which the user can filter to a particular week.
I do not think there is a functionality as such implicitly available in Sense yet. But you can achieve it using an extension for sure.
Could you please explain how can'I do it?
Thanks for your help,
If you build an extension with one measure , which takes in an expression:
for example: max(Year)....this would always give the max year and that value can be made use of to make a selection using this js
self.selectValues( dim, [value], true );
This will can potentially default a selection.
Thought this would be of help to you:
QlikSense - how to set an initial selection in the URL?
Let easy, with two pivot tables one with set analysis and other without => It works !
Thank you all for help!