topic Re: date format in QlikView

date format

upaliwije — Thu, 25 Sep 2014 08:20:22 GMT

I have two fact tables which I link through following code

LOAD POLICY_NO

& ' | ' & BCOD

& ' | ' & POL_PERIOD_TO // date field

& ' | ' & PRD_CODE

as Key_Field,

731|BC|10-JUN-2014|1A KEY FIELD FROM TABLE 1

731|BC|41657|1A KEY FIELD FROM TABLE 2

I have used the following script in data load for the date field POL_PERIOD_TO

date(floor(POL_PERIOD_TO),'DD-MMM-YYYY') AS POL_PERIOD_TO,

But date (POL_PERIOD_TO) is returned in two different formats as highlighted in red above. I presume due to this problem expected results are not returned from the data.

Is it possible ?

If so how can I correct it please ?

Re: date format

MK_QSL — Thu, 25 Sep 2014 08:31:45 GMT

Use as below :

LOAD POLICY_NO

& ' | ' & BCOD

& ' | ' & Date(Date#(POL_PERIOD_TO,'DD-MMM-YYYY')) // date field

& ' | ' & PRD_CODE

as Key_Field,

Re: date format

tobias_klett — Thu, 25 Sep 2014 08:33:46 GMT

Hi,

I prefer to use numerics of the Dates in keys: ...& num(POL_PERIOD_TO) &...

Tobias

Re: date format

anbu1984 — Thu, 25 Sep 2014 08:34:34 GMT

What is the format of date in col "POL_PERIOD_TO" from Table1 and Table2?

Re: date format

upaliwije — Thu, 25 Sep 2014 08:46:26 GMT

Numeric in both tables

Re: date format

anbu1984 — Thu, 25 Sep 2014 09:47:09 GMT

Then use as is in the Key. Dont need to change that to date format in Key.