Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

extract data from a range of date

Hi

i use 2 variables.

1)vFrom (eg. 11/11/2016)

and

2) vTo (example 13/11/2016).

Example:

From (11/November/2016)

vTo (13/November/2016)

OrderDate: I need to extract all data that fall between the range of date (11/november, 12/november, 13/novembre)

My idea is to use a similar formula:

only(If([OrderDate] >= vFrom and <= vTo, [OrderDate], 'error')

but it doesn't work.

Could you suggest a "method"?

Thanks

10 Replies
Highlighted
Partner
Partner

Hi Fabio,

go to web: Qlik Branch

and download the extension SenseDateRangePicker

A date range picker extension for qliksense

Based on http://www.daterangepicker.com/

Can be turned into a single date picker in the Calendar Settings. Also at Calendar Settings can choose all language locales that moment.js supports