topic Re: Capitalize and Abbreviate in QlikView

Capitalize and Abbreviate

snehasimha — Fri, 11 Feb 2022 14:35:01 GMT

Dear All

I want to capitalize and abbreviate the field month.How do i use both the formulas together.Kindly help me .

Regards

Sneha Simha

hic — Fri, 11 Feb 2022 15:50:15 GMT

Make sure that the MonthNames in the beginning of the script are the way you want them.

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

Then the Month(Date) function will return what you want.

snehasimha — Sat, 12 Feb 2022 08:15:18 GMT

Thank you Henric_Cronström

Mine is an excel data uploaded, i want to use the functions .

Regards

Sneha Simha

MarcoWedel — Sat, 12 Feb 2022 20:57:35 GMT

please post some examples of what you have and what you want