topic Month Name Problem After Loading in QlikView From Excel File in QlikView

Month Name Problem After Loading in QlikView From Excel File

suresh_rawat — Wed, 14 Mar 2012 04:45:47 GMT

Hi All,

When i load an excel file that only contains a Date field in QlikView, the month name is not showing properly.

For Example - It Shows dic as December instead of dec etc.

It Shows like this. I also attach my excel file please let me know what's the problem.

hic — Wed, 14 Mar 2012 15:32:15 GMT

In the beginning of the script you have a line that defines the month names. The content of this line depends on your locale.

In English:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

In Swedish:

SET MonthNames='jan;feb;mar;apr;maj;jun;jul;aug;sep;okt;nov;dec';

Check that this line is OK and that you have the right locale.