article Primer for QlikView Date fields in Member Articles

Primer for QlikView Date fields

hic — Tue, 31 Jan 2012 13:42:58 GMT

QlikView has an intelligent algorithm to recognize dates independently of which region you are in. In most cases, you will have no problems loading them. It just works and you do not need to think about it. However, in some cases dates are not properly recognized and then you need to add some code in the script to make it work.

HIC

Re: Primer for QlikView Date fields

Wed, 18 Jul 2012 09:57:52 GMT

VERY useful document!

Re: Primer for QlikView Date fields

hic — Thu, 19 Jul 2012 08:39:06 GMT

Glad you like it. This text has however been re-written slightly since I posted it. You can find the latest version on

http://community.qlik.com/docs/DOC-3102
http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

HIC

Re: Primer for QlikView Date fields

Mon, 13 Aug 2012 16:09:36 GMT

hi,

Can anyone please tell me about ,what is inyeartodate funcion with example

Regards

Ramesh

Re: Primer for QlikView Date fields

Tue, 30 Apr 2013 16:33:15 GMT

Excelent article you sabe me a lot of time

Re: Primer for QlikView Date fields

cotiso_hanganu — Wed, 04 Sep 2013 15:07:40 GMT

@rameshmca

let's assume we have a variable that has:

vDate = 1-feb-2013

and a table with sales in 2012 up to september 2013, with TransactionDate as the field containing the date of the transaction

inyeartodate(vDate,TransactionDate,0) will return you true(), aka -1 for all the lines with TransactionDate<=vDate and TransactionDate>=yearstart(vDate)

=> you can get sales from the begining of the year until vDate with a formula like this:

sum(-inyeartodate(vDate,TransactionDate,0) * Sales)

Re: Primer for QlikView Date fields

Anonymous — Wed, 04 Sep 2013 16:39:37 GMT

Thanks Henric., once again.

I save all your documents and tips anywhere in my private QV Knowledge Base. (QVKB)