topic Re: QlikView Dates in QlikView

QlikView Dates

kangaroomac — Tue, 27 Nov 2012 09:30:20 GMT

Good Day,

I am trying to get a maximum date in a variable. I have created a date, using date# and makedate in the script. The date displays correctly in a listbox.

When using a text box I use the following expression: =Date(Max(Floor(myDate)), 'DD/MM/YYYY') - It Displays correct.

When I use the same expression when creating a variable though, I get 0.00002485....

Does anyone please have any Ideas why?

Re: QlikView Dates

Anonymous — Tue, 27 Nov 2012 09:33:59 GMT

Could it be that your variable actually evaluates the date mathematically..

27/11/2012 could potentially be 27, divided by 11, divided by 2012.

I think it has something to do with how you've defined or are calling your variable.

Re: QlikView Dates

Tue, 27 Nov 2012 10:01:53 GMT

this code ll load the max date value in script variable

date1:

LOAD date(date#(ChangeDateID,'YYYYMMDD'),'DD/MM/YYYY') as ChangeDateID,

ChangeDateID as de,

(MonthID) as MonthID ,

date(date#(StockDateID,'YYYYMMDD'),'DD/MM/YYYY') as StockDateID

FROM

(ooxml, embedded labels, table is TB02_20120823_120900);

table:

LOAD max(ChangeDateID) as maxdate,

RowNo() as r

Resident date1;

let vardate=date(Peek('maxdate',0,'table'));

drop Table table;

Re: QlikView Dates

kangaroomac — Tue, 27 Nov 2012 10:19:31 GMT

Thank you everyone for your reply. I have tried all the above, but unfortunately to no avail. I have uploaded a "quick and dirty" example of what I mean.

The day devided by month sounds logical - but does not calculate to the same number when I manually devide them with a calculator.

Using the peek function to get the max gives me a differnt (8.25.... outcome) instead of the desired date.

Re: QlikView Dates

Anonymous — Tue, 27 Nov 2012 10:22:42 GMT

My calculator gets the divided value I mentioned before.

Solution is to quote the variable when referencing it. Change your text object to this:

='vMaxDate:' & chr(10) & '$(vMaxDate)'