Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Govind
in calendar options settings add this like below
so that calendar object will take min and max date available :
regards
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..
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
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 !!
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