dates in application

kaygee28 — Mon, 21 Nov 2016 19:26:07 GMT

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:

Re: dates in application

Anonymous — Mon, 21 Nov 2016 19:41:39 GMT

I do not know how it works in the spreadsheets, but it looks like it really does not have dates for these events.

Re: dates in application

kaygee28 — Mon, 21 Nov 2016 19:53:40 GMT

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

Re: dates in application

Anonymous — Mon, 21 Nov 2016 20:18:09 GMT

I'm happy to help.

topic dates in application in QlikView

dates in application

Re: dates in application

Re: dates in application

Re: dates in application