Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

Primer for QlikView Date fields

cancel
Showing results for 
Search instead for 
Did you mean: 
hic
Former Employee
Former Employee

Primer for QlikView Date fields

Last Update:

Jan 31, 2012 8:42:58 AM

Updated By:

hic

Created date:

Jan 31, 2012 8:42:58 AM

Attachments

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

Tags (3)
Comments
Not applicable

VERY useful document!

hic
Former Employee
Former Employee

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...

HIC

Not applicable

hi,

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

Regards

Ramesh

Not applicable

Excelent article you sabe me a lot of time

cotiso_hanganu
Partner - Creator III
Partner - Creator III

@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)

Anonymous
Not applicable

Thanks Henric., once again.

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

Version history
Last update:
‎2012-01-31 08:42 AM
Updated by:
Former Employee