topic computer vs qlikview date/time misalignment in QlikView

computer vs qlikview date/time misalignment

yelin_nyu — Fri, 04 Oct 2013 15:24:48 GMT

my computer and qlikview docs date/time sequence is off.

I did an expression monthend(date_field), date field='6/30/13, but the returned value is '5/31/2013'.

Once I did weekday(date_field), and returned Tues. should be sun

how do I fix this? I know I can change the sequence in script set statement, but since I share multiple machines with teammates, other machines are right, but this one is off.

Thanks

Re: computer vs qlikview date/time misalignment

swuehl — Fri, 04 Oct 2013 15:51:49 GMT

I can only imagine an issue with date formats or date manipulation, but really hard to tell with the information given.

Could you upload a small sample app that demonstrate this issue?

Re: computer vs qlikview date/time misalignment

yelin_nyu — Fri, 04 Oct 2013 15:57:16 GMT

I can't, because if u download the file to your drive since you have correct setting in your computer, then monthstart(10/04/2013) going to give you 10/1/2013.

my bad computer give me 9/1/2013

I opened the same document on a different computer, then it's 10/1/13

I wasn't doing anything fancy, just a text box with a simple function

Re: computer vs qlikview date/time misalignment

swuehl — Fri, 04 Oct 2013 16:00:27 GMT

Well, maybe a close look to your app's settings and script may help to understand the problem.

For example, what standard date formats are used in your script?

Re: computer vs qlikview date/time misalignment

Clever_Anjos — Fri, 04 Oct 2013 16:05:53 GMT

Could you post your Date/Time settings?

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez';

SET DayNames='seg;ter;qua;qui;sex;sáb;dom';

Re: computer vs qlikview date/time misalignment

yelin_nyu — Mon, 21 Oct 2013 14:27:42 GMT

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

I need to show you a demo, sorry got so busy. I just avoided using that machine for tool reloading. but I would like to figure this out