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

    Date Range Extension

    Govind Ramchetty

      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

        • 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 :

          regards

            • Re: Date Range Extension
              Govind Ramchetty

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

                • Re: Date Range Extension
                  bruno bertels

                  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