Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.