Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kaygee28
Contributor III
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
Creator III
Creator III

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
Creator III
Creator III

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

kaygee28
Contributor III
Contributor III
Author

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
Creator III
Creator III

I'm happy to help.