Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

Date Range selection

Hi All

 

I have a scenario like i need to develop a table(having vehicle number and corresponding delivery date) for rolling  12 months . And  we need to select a date range in filter where the output should contains the vehicles having delivery date less than maximum  date range selected in filter.

 

Regards

Eleena

3 Replies
Partner
Partner

Re: Date Range selection

Hello,

 

Consider this sample data set

Load * Inline
[VechicleNumber,DeliveryDate
101,01/01/2019
102,02/04/2018
103,03/06/2018
104,04/08/2018,
105,05/08/2018];

 

Output :

PFA

Partner
Partner

Re: Date Range selection

Thank you Shivani.

 

But we need all date data in filter (not only delivery dates) to select data range.And we need to get deliver dates in that data range  .  For example filter should contain 

Oct-18
Nov-18
Jan-19
Feb-19
Mar-19

and so on..

 

Regards

Eleena

 

Partner
Partner

Re: Date Range selection

Create a field by concatenating month and year and pass it instead of  "deliverydate"  and if you want 2 dates for a range then try this set analysis:

 

Count({<DeliveryDate={">=(min(DeliveryDate))<$(=$(max))"}>}distinct VechicleNumber)