Date Filter (Today)

[BrianDH]

Team

I need to add a date filter to my sheet.  I'd like it to default to "TODAY" with the option to change. 

My user only wants to see today's data when the app opens.   With an option to remove or change.

Thanks for the help

B

[JustinDallas]

Do you have a master calendar? Or does your fact table have a datefield?  If it does, you can create another field called [In Today].

LOAD *,

If( InToday(SomeDate), 'Y','N' ) AS 'InToday'

...

---

You do this by doing the following steps:

-Duplicate App to your work folder.

-Modify the script so that there is a field that restricts to today

-Reload Script

-Select "InToday"='Y' in the app

-Create a bookmark

-Right click bookmark and click the "Set selections as app default"

-Republish the app

Here is what I am talking about with respect to the bookmark

Let me know if this helps.

[BrianDH]

Master Calendar?

Yes it ha a date field (v_entered_dttm)

[JustinDallas]

Then use the "v_entered_dttm" field to create your flag field "Is In Today" Y/N.

[BrianDH]

I added: 

,If(InToday(PS_VOUCHER.ENTERED_DTTM), 'Y','N' ) AS 'InToday'

Into my LOAD SQL Script.  I get an error 

[Mauritz_SA]

Hi there Brian

While adding a flag is always nice and I am sure it will work, you can also type a formula in the selections bar which equates to today's date and save it as your default bookmark. This 4 minute video explains it very nicely.

Regards,

Mauritz

[BrianDH]

I added a filter pane.  I am using (Entered dttm) as my dimension (=Date(floor(V_ENTERED_DTTM),'yyyy-MM-dd'))  Now I see all the dates. 

How do I get it to default to todays date?

Thanks

[Mauritz_SA]

Hi Brian

I'm not close to Qlik right now, but you should able to type:

=Date(Today(),'YYYY-MM-DD')

That's assuming your date field is also in a YYYY-MM-DD format. If you want to you can post your app and I can help you tomorrow morning.

Regards,

Mauritz

[BrianDH]

This is what I have now (filter Pain populated by date field) "=Date(floor(V_ENTERED_DTTM),'yyyy-MM-dd') "

I want it to default to the most recent date which should be Today/Now when moved to production

How can I push it to Today()Filter Pane with dates

[Mauritz_SA · Accepted solution]

Hi Brian

Using the following in the filter pane (or finding the field in your Selections tool) and then bookmarking it and setting it as your default bookmark should work:

=Floor(<Your Date Field>)=Floor(Today())

I guess it will be the following if your date field is [ENTERED DTTM]:

=Floor([ENTERED DTTM])=Floor(Today())

Hope this helps 🙂

Regards,

Mauritz