extract data from a range of date

[fmazzarelli]

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

[fmazzarelli]

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