Date Range Extension

[#1]

HI

I am using Date Range Extension in my report (Act_Start_Date). When i select my date, it not able to change my report.Any configuration i missed/Please let me know.

Date Range Extension downloaded from below path:

GitHub - NOD507/SenseDateRangePicker: A date range picker extension for qliksense

Thanks

Govind R

[brunobertels]

Hi Govind

in calendar options settings add this like below

so that calendar object will take min and max date available :

regards

[#3]

I added like what you said. Till not able to change.

E.g

In date range prompt i selected (10/12/2015 to 30/2/2016). after selection date my report not changing.

Can you please check my attached qvf file..

[brunobertels · Accepted solution]

Hi

the problem comes from your field ACT_START_DATE who is a timestamp fild format ( I mean DD/MM/YYYY HH:MM:SS.ffff format

the date picker only recognise date format without timestamp

So the solution is to

1 :

add a line script in your script like this :

Date(Floor(Date(ACT_START_DATE,'MM/DD/YYYY hh:mm:ss.ffff')),'DD/MM/YYYY') as date,

! !

then use date dimension in the daterange picker extension

2 :

add this

Date(Floor(Date(ACT_START_DATE,'MM/DD/YYYY hh:mm:ss.ffff')),'DD/MM/YYYY')

in the dimension of date range picker

I send you back your app modified

[shwetagupta]

Hi Bruno and Govind,

I was following this thread and solution.

One thing I would like to know, doesnot this extension include SUNDAY or what [11/13] signifies in the attached.

Thanks in advance !!

[brunobertels]

Hi Sweeta

this extension is based on the date field you choose; based on calendar field or date field included in your dataset.

Here 11/13 means that 13 dates are selected in the range but only 11 of them have data.

here there is no data available in the dataset fort the 10th and 11th of december