Problem with matching fields on the sheet (tables aren't linked)

[#1]

Hi guys! I have created a Master Time Calendar but when I edit the sheet it doesn't match the fields. For example, I select the timestamp "2/11/2015 06:18" but in hour and month qlik doesn't highlight "6" and "Feb" respectively. Any help?

[sorrakis01]

Hi,

You are in qlikview forum not in Qlik Sense Forum.

regards

[datanibbler]

Hi Anna,

do you have hour and month and so on in separate fields?

Can you post a sample to illustrate your issue?

[#4]

Yes, they are seperated.

As I see in the data model viewer the tables are not linked. How can I fix it?

[#5]

And here is the code:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='hh:mm';

SET DateFormat='MM/DD/YYYY';

SET TimestampFormat='MM/DD/YYYY hh:mm' [.fff];

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

[applesp]:

LOAD [AddedTimeStamp],

  [Open]

FROM [lib://Documents/Script.xlsx]

(ooxml, embedded labels, table is applesp);

[tabCalendar]:

LOAD

     DayName(AddedTimeStamp) as Date,

     Hour(AddedTimeStamp) as Hour,

     Day(AddedTimeStamp) as Day,

     WeekDay(AddedTimeStamp) as WeekDay,

     Week(AddedTimeStamp) as Week,

     WeekName(AddedTimeStamp) as WeekName,

     Month(AddedTimeStamp) as Month,

     MonthName(AddedTimeStamp) as MonthName,

     Ceil(Month(AddedTimeStamp)/3) as Quarter,

     QuarterName(AddedTimeStamp) as QuarterName,

     Year(AddedTimeStamp) as Year,

     WeekYear(AddedTimeStamp) as WeekYear;

LOAD Timestamp(MinDate+(IterNo()-1)/1440, 'MM/DD/YYYY hh:mm') as AddedTimeStamp

While MinDate+(IterNo()-1)/1440<=MaxDate;

LOAD Floor(Min(AddedTimeStamp)) as MinDate,

     Ceil(Max(AddedTimeStamp)) as MaxDate

Resident applesp;

[#6 · Accepted solution]

Write in your tabCalender the AddedTimeStamp Field, then you will have the link to the table applesp.

[#7]

Thank you for your quick response! But now I have null values too! how can I fix it?

[#8]

I fixed it! Thank you all for your time