topic Select two dynamic date ranges with a button in QlikView

Select two dynamic date ranges with a button

felix18807 — Tue, 06 Nov 2012 16:11:59 GMT

Is there any way of getting a date range selected using a button for the filter below?

Basically I want to be able to dynamically select from April this year to today AND from April last year to 1 year ago today.

='(>=$(=yearstart(addyears(today(),-1),0,4)) ' &
'<$(=addyears(today(),-1))) AND ' &
'(>=$(=yearstart(today(),0,4)) ' &
'<$(=today()))'

Many Thanks

MayilVahanan — Tue, 06 Nov 2012 16:58:44 GMT

Try like this

='((>=$(=yearstart(today(),0,4)) ' & '<$(=today()))' & '*|*' &'(>=$(=yearstart(addyears(today(),-1),0,4)) ' &'<$(=addyears(today(),-1))))'

Hope it helps

felix18807 — Wed, 07 Nov 2012 08:42:16 GMT

Ahh it was the | character that I was missing! TYVM