topic Re: Date Range in QlikView

Date Range

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

How i get values between one particular date to another,

Ex,

=sum({<SalesNumDate={">=$('01-05-2010')<=$('01-05-2016' )"}>}BILLSTONECARAT)

both date this (dd-mm-yyyy) format only but not able to get values kindly let me know how to get values bw two different dates which is hard-coded...

Thanks in advance...

Gysbert_Wassenaar — Wed, 13 Jul 2016 11:02:49 GMT

You could try this:
=sum({<SalesNumDate={"=SalesNumDate>=MakeDate(2010,5) and SalesNumDate<=MakeDate(2016,5)"}>}BILLSTONECARAT)

Anonymous — Wed, 13 Jul 2016 11:08:31 GMT

if you would like work with dates only

=sum({$<SalesNumDate={'>=01-05-2010<=01-05-2016' }>} BILLSTONECARAT)

if you would like work dates with variables

Sum({$<SalesNumDate={'>=$(=Date(vFromDate, 'DD-MM-YYYY'))<=$(=Date(vToDate, 'DD-MM-YYYY'))'}>} BILLSTONECARAT)

Thu, 14 Jul 2016 06:18:46 GMT

Hi GD,

Thanks it worked well...