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

                    • 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 !!
                      Daterange.png

                        • 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