Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to put date range calendar in Qliksense

Hi Every one,,

In my report I want to see only particular date range Invoices . How do i achieve this. .can you please help me..

If you have example QVF file please send it to me..

5 Replies
ogster1974
Honored Contributor II

Re: How to put date range calendar in Qliksense

Try using the qsvariable extension to set a variable based on your date ranges under a button or slider then use the value to set your filter on the measure you want reported.

Re: How to put date range calendar in Qliksense

I quite like the SenseDateRangePicker extension available here on Qlik Branch 

Not applicable

Re: How to put date range calendar in Qliksense

Hi,

I used this Date Range picker, But For ODBC connection tables not working..., It is working for only Excel files.

Re: How to put date range calendar in Qliksense

Try checking your date formats for ODBC vs Excel data sources.

I would guess that you are formatting your dates from Excel ok, but not your dates from ODBC.

wayneantinore-a
Contributor

Re: How to put date range calendar in Qliksense

Hi I've had this problem with dates pulled from a database table as well.  My workaround has been to wrap the date field in the Qlik Date function.  Then the date range picker works.  For the dimension definition make it a formula like this =Date(<Your-Date-Field-Name>)