topic Re: source date key vs calender date key issue in QlikView

source date key vs calender date key issue

Anonymous — Tue, 28 Feb 2012 08:49:59 GMT

hi folks,

whats wrong in the script

date key created by adding month and year from source as date key

iam trying to join source date key with calender date key

iam not getting the association

plz help me out

plz find sample qvw

source date key vs calender date key issue

anderslinden — Tue, 28 Feb 2012 09:22:08 GMT

Hi!
You have a few issues. First you need to have a daynumer. I tried using the invoicedate instead to get the link and it links. Your issue here is that invoice date is not always in the invoicemonth. You need to know how the user want to sort invoice dates into invoice month. The link works: date(InvoiceDate,'M/DD/YYYY') as DateKey

Re: source date key vs calender date key issue

Anonymous — Tue, 28 Feb 2012 14:11:13 GMT

hi anders,

i have invoice year, invoice month field.

how can i achieve datekey by using makedate? to join with calender date

invoice month --3,4.........

invoice year 2002,2003,..............

help me out

Re: source date key vs calender date key issue

CELAMBARASAN — Tue, 28 Feb 2012 14:28:30 GMT

Hi,

You can use

MakeDate([invoice year],[invoice month]) as Date

Celambarasan

Re: source date key vs calender date key issue

anderslinden — Tue, 28 Feb 2012 14:43:38 GMT

hi
I can see that you have mixed ut the order between year and month. Change

date (makedate(InvoiceMonth, InvoiceYear) into

date (makedate(InvoiceYear,InvoiceMonth), 'M/DD/YYYY') as DateKey

/Anders