topic Re: why it not mapping properly in QlikView

why it not mapping properly

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

i try to get hour field in master calendar but Master calendar link key is not mapping with Data Tables

What i did wrong? why its duplicated?

swuehl — Sat, 20 May 2017 14:50:53 GMT

That's because you only formatted the text representation, and the numeric part kept unchanged (and the numeric part is used for the key match).

try to adapt the numeric part, too, e.g.

Timestamp#(Timestamp(TimeStamp,'MM/DD/YYYY HH'),'MM/DD/YYYY HH') as MasCalLink

sunny_talwar — Sat, 20 May 2017 14:51:44 GMT

Try this

GasResponse:

LOAD ISR_NO,

CREATED_DATETIME,

Timestamp(Floor(CREATED_DATETIME, 1/24),'MM/DD/YYYY HH') as MasCalLink,

Timestamp(Floor(CREATED_DATETIME, 1/24),'MM/DD/YYYY HH') as MasCalLink1,

RESPONSE_TIME

FROM

[try.xls]

(biff, embedded labels, table is Sheet1$);

Calendar:

LOAD Year(TimeStamp) as Year,

MonthName(TimeStamp) as MonthYear,

Month(TimeStamp) as Month,

Day(TimeStamp) as Day,

Date( Floor( Date(TimeStamp)),'MM/DD/YYYY') as Date,

Hour(TimeStamp) AS Hour,

Timestamp(Floor(TimeStamp, 1/24),'MM/DD/YYYY HH') as MasCalLink ;

LOAD

Timestamp($(vMinDate) + (RecNo() - 1)/24) as TimeStamp

AUTOGENERATE 23 * $(vDays);

tripatirao — Mon, 22 May 2017 07:12:20 GMT

Hi Sunny,

How below code works

LOAD

Timestamp($(vMinDate) + (RecNo() - 1)/24) as TimeStamp

AUTOGENERATE 23 * $(vDays);

Can you please explain

Regards

Tripati

Peter_Cammaert — Mon, 22 May 2017 07:34:23 GMT

For a fixed series of vDays full day calendar entries (all hours), you may want to change the 23 into 24.