Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
john_duffy
Partner - Creator III
Partner - Creator III

QlikView 10 date format question

Hello All.

We are migrating from QV 8.5 to QV 10 SR2.  I am currently loading and testing all of our apps in version 10.

In one app I have the following very simple piece of code which loads data from a spreadsheet:

Test_Table:

     Load 'Test ' & EFFDATE & '-' & MonthEnd (If(isnull(ENDDATE),Now(),ENDDATE)) as MonthKey,

             EFFDATE,

             MonthEnd(If(isnull(ENDDATE),Now(),ENDDATE)) as ENDDATE

     From Test.xls ....;

Test2_Table:

     Load

             'Test2 ' & EFFDATE & '-' & ENDDATE     as MonthKey2

     Resident Test_Table;

The fields EFFDATE and ENDDATE are in the format MM/DD/YYYY.

When I load this script in v8.5, the value for ENDDATE in MonthKey2 is in the MM/DD/YYYY format.

When I load this script in v10, the value for ENDDATE in MonthKey2 is in numeric format.

I can work around this issue by applying the MonthEnd function again on ENDDATE when creating MonthKey2.

Any ideas why this date format is different between versions v8.5 and v10?

Thanks,

John.

3 Replies
Not applicable

Hi John,

Did you figure out the difference yet? Please share. We are migrating from 8.5 to 10 as well and it will be really helpful if you can share what other small changes you noticed or that bothered you.

Abha

john_duffy
Partner - Creator III
Partner - Creator III
Author

Hi Abha.

For the issue above, I simply used my work around (ie. applying the MonthEnd function).

We didn't run into any major issues when upgrading from v8.5 to v10.  Most were formating issues that I was able to work around.  I did report a few issues as bugs (see attached document).  Some were fixed, some QlikTech deemed as working as designed and some I'm not sure if they were fixed in later versions.

I do not work with Publisher at our shop.  The person who maintains Publisher said v10 is quite different that v8.5.  He claims that it was more time consuming and complicated to set up tasks and schedules in v10.

We find that our applications run faster on the v10 server.  Also, in v8.5 we periodically had charts fail on memory.  Users would not be able to open the charts until the server was bounced.  We have not had this issue in v10.

Hope this helps,

John.

Not applicable

John,

Thank you so much. It did help. Thank you again.

Abha