Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
andrea_trinity
Partner - Contributor
Partner - Contributor

Default Selection Plugin

Hi All, I am new to Qlik Sense and I've been reading the posts on showing a default filter, however thus far it has not worked for me. My Scenario is one where by when the user lands on a particular sheet, that sheet will be filtered. This sheet will be filtered by Today() date. The field that I am currently using was a date field, however it has been modified in the following manner: Date(Floor((ModifyDateTime))) AS MODIFYDATETIME.

qlik sense 1.png qlik sense 2.png

Some of the following Field Value that I have tried on the date field are:

Today()

Today

=Today()

=Date(Today())

'10/20/2018'          *This a random date that has a record in my table

10/20/2018

'20/10/2018'

20/10/2018

='10/20/2018'

=10/20/2018

='20/10/2018'

=20/10/2018

I know the extension is working for other type of fields (e.g. text).

The end outcome that I would like to achieve is the following:

qlik sense 3.png

A simple filter on this sheet by today (i understand there is another parameter now, but I only need for Today()) so that the users can cancel out this filter when they need to.

Please guide me on this thank you.

0 Replies