Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kaygee28
New Contributor III

dates in application

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:

register.png

1 Solution

Accepted Solutions
marcioarruda
Contributor III

Re: dates in application

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

teste.JPG

View solution in original post

3 Replies
marcioarruda
Contributor III

Re: dates in application

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

teste.JPG

View solution in original post

Highlighted
kaygee28
New Contributor III

Re: dates in application

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

marcioarruda
Contributor III

Re: dates in application

I'm happy to help.