topic Re: How to Display January as Jan in QlikView

How to Display January as Jan

Sat, 31 Jan 2015 17:22:50 GMT

Hello,

I have a lot of data coming in with Months as January, February, March, etc... In an effort to save a little space on my charts I would like to display these months as Jan, Feb, Mar, etc...

I have left the default Set values in place but I cannot seem to figure out how to use these.

Currently my data in loading from a QVD and looks like this:

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';

Directory;

LOAD Segment,

Month,

Year,

[Segment Monthly Cost],

Fail,

Pass,

Remediated,

[Complete by Target],

[Complete by Original],

[Projects not complete],

[Budget of not complete],

[BV of not complete],

[Projects complete],

[Budget of completed],

[BV of completed],

[Microsoft Patch %],

[3rd Party Patch %],

[AV Compliance],

Total_Team_Member,

Total_IT_Team_Member,

Total_Contractor,

Voluntary_Turnover,

[# of Recordables],

[# of Lost Days],

[Total Lost Time]

FROM

ITDashboard_AllJoin.qvd

(qvd);

Can someone offer me some advice on how to convert these Months to display in three letters rather than the full name?

Re: How to Display January as Jan

Anonymous — Sat, 31 Jan 2015 17:31:20 GMT

Hi!

you can use left(Month, 3) to catch just first 3 letters or month(Month) that should use your variable setup for month name.

Elena

Re: How to Display January as Jan

Anonymous — Sat, 31 Jan 2015 17:42:59 GMT

Hi,

Try below code in script:

Month(Date#(Month,'MM')) as Month_Short;

Re: How to Display January as Jan

maxgro — Sat, 31 Jan 2015 17:48:29 GMT

add to the SET section of the script

SET LongMonthNames = 'January;February;March;April;May;June;July;August;September;October;November;December';

then you can interpret the field Month and get a 3 char Month in your load

load

.....

Month(Date#(Month,'MMMM')) as ShortMonth,

.....

Re: How to Display January as Jan

Sat, 31 Jan 2015 17:50:16 GMT

Thank you. That worked perfect.

Re: How to Display January as Jan

Sat, 31 Jan 2015 17:51:12 GMT

That worked well if I put it inside of the dimension on that chart but couldn't get that to work in the script.

Thanks for the help.

Re: How to Display January as Jan

Anonymous — Sat, 31 Jan 2015 17:52:33 GMT

You're Welcome.

Regards

Neetha