Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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