5 Replies Latest reply: Aug 22, 2016 3:03 AM by Bruno Bertels RSS

    Date Range Extension


      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

              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