Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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?
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. .
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?
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
];
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 : ='/'