Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

date range options

Hi

(eg)I am creating a bar chart listing no.of orders placed by each customer in my database. now i wish to see the only the no of orders placed by him from this particular date to this particular date. kindly give with examples

1 Reply
giakoum
Honored Contributor II

Re: date range options

Assuming that particular dates limits are placed in variables vFromDate and vToDate :

count({$<[OrderPlacedDate]={">=$(vFromDate)<=$(vToDate)"}>} [Orders])

Community Browser