5 Replies Latest reply: Oct 31, 2017 11:15 AM by Prashant Sancheti RSS

    DateRangePicker Extension not working

    Prashant Sancheti

      Hi All ,

       

      I have installed Qliksense Desktop June 2017 and using date range picker extension.

       

      But it is not working like i can not able to select all the dates  please let me know if i need to change some setting.


      This is the script i am using:

       

      SET DateFormat='M/DD/YYYY';

      SET TimestampFormat='M/DD/YYYY h:mm:ss[.fff] TT';

       

      TA:

      load * Inline

      [

      BusinessDate

      1/1/2010

      1/2/2010

      1/3/2010

      1/4/2010

      1/5/2010

      1/6/2010

      1/7/2010

      ];

      load

      Date(Left(BusinessDate, 10), 'MM/DD/YYYY') AS NewBusinessDate

      Resident TA;

       

      in the extension level i am using NewBusinessDate as Dimension

       

      min Date: min(NewBusinessDate)

       

      max Date: max(NewBusinessDate)

       

      Start Date :  min(NewBusinessDate)

       

      Date Format in Options : ‘MM/DD/YYYY’

       

      But when I select Date its not working for all dates.Please let me know if any thing need to be done .

        • Re: DateRangePicker Extension not working
          Mark Ritter

          Which extension are you using?

           

          I just downloaded and installed the one called SenseDateRangePicker and it is working fine on my system.

           

          I suspect you may have a data format issue if it is not working for you.  Also, what do you mean it is not working for all dates?

          • Re: DateRangePicker Extension not working
            Prashant Sancheti

            Hi Ritter,

            Thanks for reply.

            Could you please share the qvf file so i can verify if i have missed anything.

            The selection is not working as expected.  .

              • Re: DateRangePicker Extension not working
                Mark Ritter

                I can't share the QVF unfortunately.

                 

                I can tell you that my app uses all of the standard SET statements.  I am using a date field from my QVD that originally came from a database.

                 

                The extension works perfectly.

                 

                Question.  BusinessDate is only 8 characters long in your Inline data.  Why are you do a Left with 10?  Have you confirmed that your NewBusinessData actually contains what you expect it to?

              • Re: DateRangePicker Extension not working
                omar bensalem

                change as follow:

                 

                TA:

                 

                 


                load *,

                Date(date#(BusinessDate, 'M/D/YYYY'), 'MM/DD/YYYY') AS NewBusinessDate


                Inline

                [

                BusinessDate,

                1/1/2010

                1/2/2010

                1/3/2010

                1/4/2010

                1/5/2010

                1/6/2010

                1/7/2010

                ];

                  • Re: DateRangePicker Extension not working
                    Prashant Sancheti

                    Hi Ritter,

                    Thanks for reply.

                    I have created one more app where I am loading data from excel: But still this extension is not working.

                    Could you try selecting different dates and see whether its working

                    BusinessDate

                    12/31/2004

                    01/01/2005

                    01/02/2005

                    01/03/2005

                    01/04/2005

                    01/05/2005

                    01/06/2005

                    01/07/2005

                    01/08/2005

                    01/09/2005

                    01/10/2005

                    01/11/2005

                     

                    SET ThousandSep=',';

                    SET DecimalSep='.';

                    SET MoneyThousandSep=',';

                    SET MoneyDecimalSep='.';

                    SET MoneyFormat='$#,##0.00;-$#,##0.00';

                    SET TimeFormat='h:mm:ss TT';

                    SET DateFormat='M/D/YYYY';

                    SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

                    SET FirstWeekDay=6;

                    SET BrokenWeeks=1;

                    SET ReferenceDay=0;

                    SET FirstMonthOfYear=1;

                    SET CollationLocale='en-US';

                    SET CreateSearchIndexOnReload=1;

                    SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

                    SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

                    SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

                    SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

                    LOAD

                    Date(BusinessDate, 'MM/DD/YYYY') AS BusinessDate

                    FROM [lib://Copnection/BuisnessDate.xlsx]

                    (ooxml, embedded labels, table is Sheet1);

                     

                     

                    **************************************

                    Report:

                    Dimension : BusinessDate

                    Single Date Switch :On

                    min Date: '12/31/2004'

                    max Date: date(firstworkdate(Date(Now()-1), 1), 'MM/DD/YYYY'

                    Start Date :  date(firstworkdate(Date(Now()-1), 1), 'MM/DD/YYYY')

                    Range Switch :OFF

                    Date Format in Options : ‘MM/DD/YYYY’

                    Separator : ='/'