Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day I've had this problem before but I cant seem to resolve it
I have a graph which needs to reflect a time series within the PaidDate column ! !@ ! !@, but the other two graphs don't display a time series for some reason please see code below. I already verified the spreadsheets and the columns are saved as dates. The last two sheets that have been included in the app don' ! !t display in the time time series it just a total of them at the end of the graph
Directory;
Pri:
LOAD EventName,
Description,
personid,
dateofbirth,
idnumber,
PassportNo,
Surname,
Firstnames,
EntryStatus,
GenderDesc,
email,
cellno,
Prefix,
EventNo,
Starttime,
GroupDescription,
GroupName,
RacePackBarcode,
Age,
PaidDate,
FROM
[CC NC Data 20161018.xlsx]
(ooxml, embedded labels, table is [NC Data]);
Directory;
Concatenate(Pri)
LOAD EventName,
Description,
personid,
dateofbirth,
ID,
Passport,
Surname,
Firstnames,
EntryStatus,
GenderDesc,
email,
cellno,
Prefix,
EventNo,
Starttime,
RacePackBarcode,
Age,
PaidDate,
FROM
[MTB NC Data 20161101.xlsx]
(ooxml, embedded labels, table is Sheet1);
Directory;
Concatenate(Pri)
LOAD EventName,
Description,
personid,
surname,
firstnames,
parentcellno,
GenderDesc,
email,
cellno,
EventNo,
Prefix,
Starttime,
Age,
PaidDate,
[5372Jetline Action Photo]
FROM
[KIDSALL 20161116.xlsx]
(ooxml, embedded labels, table is Sheet1);
Directory;
Concatenate(Pri)
LOAD EventName,
personid,
surname,
firstnames,
GenderDesc,
email,
cellno,
EventNo,
Prefix,
Starttime,
Category,
Age,
PaidDate,
[5483Jetline Action Photo]
FROM
[10KM FFRALL 20161116.xlsx]
(ooxml, embedded labels, table is Sheet1);
Mas_Cal:
LOAD
Date(PaidDate) as PaidDate,
Year(PaidDate) as Year,
'Q' & Ceil(Month(PaidDate)/3) as Quarter,
Month(PaidDate) as Month,
Day(PaidDate) as Day,
Week(PaidDate) as Week;
LOAD
Date(MinDate + Iterno() -1) as PaidDate
While(MinDate + Iterno() -1)<=Num(MaxDate);
LOAD
Min(PaidDate) as MinDate,
Max(PaidDate) as MaxDate
Resident Pri;
Primedia:
NoConcatenate
load*
resident Pri;
drop table Pri;
please see image of the graph:
I do not know how it works in the spreadsheets, but it looks like it really does not have dates for these events.
I do not know how it works in the spreadsheets, but it looks like it really does not have dates for these events.
Hi Marcio
You just made me realize the data they sent me have different column formats the other columns are formated in this manner 2016/09/27 01:35:31 PM, hence qlik isn't reading it as a date.
Regards
I'm happy to help.