Discussion Board for collaboration on QlikView Scripting.
In the attached QVW for the field "DeliveryDate" I want to subtract the minimum date from the maximum date for a given container number.
It doesn't work. I'm pretty sure it is because of the date format. Any suggestions what I'm doing wrong? Source html files attached as well.
Go to Solution.
you just have to change your loading script as follows to match the string date format
LOAD [Contnr ID],
date(date#(Deliv.Date,'DD.MM.YYYY')) as DeliveryDate,
Today() as ExtractDate
Yes, your problem is because of date format.
See attachef file
if you have a PE edition :
SubField( Deliv.Date,'.',3)&'-'&SubField(Deliv.Date,'.',2)&'-'&SubField( Deliv.Date,'.',1) as DeliveryDate,
left(SubField(FileName(),'-',3),4)&'-'&SubField(FileName(),'-',2)&'-'&right(SubField(FileName(),'-',1),2) as ExtractDate
// Change with your path
(html, codepage is 1252, embedded labels, table is @1);
expression in graph :