DateRangePicker Extension not working

[prashantsanchet]

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 .

[rittermd]

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?

[prashantsanchet]

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

[rittermd]

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?

[OmarBenSalem]

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

];

[prashantsanchet]

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 : ='/'