5 Replies Latest reply: Aug 22, 2016 3:03 AM by bruno bertels RSS

    Date Range Extension

    Govind Ramchetty


      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




      Govind R

        • Re: Date Range Extension
          bruno bertels

          Hi Govind


          in calendar options settings add this like below

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


            • Re: Date Range Extension
              Govind Ramchetty

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


              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..

                • Re: Date Range Extension
                  bruno bertels



                  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

                    • Re: Date Range Extension
                      shweta gupta

                      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 !!

                        • Re: Date Range Extension
                          bruno bertels

                          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