Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Filters to a default Date Range

Hello,

I have a slider/Calendar Object on a dashboard. I would like this, by default, to show a specific date range. From my reading, it says i can possibly build a macros to do this, however I do not have any experience in building a macro in Qlikview. Is there an easier way to do this right in the slider/calendar properties?

12 Replies
Not applicable
Author

So I changed it to

=>= Date(WeekStart(Max(Date))) <=Date(WeekEnd(Max(Date)))

And it says 'Garbage after expression: 'Date'

sunny_talwar

How about this:

='>=' & Date(WeekStart(Max(Date))) & '<=' & Date(WeekEnd(Max(Date)))

harithadogiparthi505
Contributor III
Contributor III

Hi sunny,

I have an issue working with qliksense setting date picker default range.

I have used the similar expression.

My dashboard consist of four sheets. When navigating from one sheet to next the default is setting correct.

While navigating back from second sheet to first show previous week data of default.

Is there any solution for this kind of issue.

Please help me with the solution.