Format Variable Tweaks

    QlikView provides the default below format variables in any new document created. The default format values are based on the local OS format settings on the machine where the document is initiated. So far so good.

     

    I commonly promote having matching values in TimestampFormat as in TimeFormat and DateFormat. By using dollar expansion the define the TimestampFormat you only have to maintain the Time and Date settings, and it ensures that your date and tiem formats are consistent.

     

    SET TimeFormat='hh:mm:ss';
    SET DateFormat='YYYY-MM-DD';
    SET TimestampFormat='$(DateFormat) $(TimeFormat)';
    
    

     

    The default format variables in QlikView are actually not complete when it comes to MonthNames. An additional format variable for LongMonthNames also exists and can be added to adjust the longer representation of each month name.

     

    SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
    SET LongMonthNames = 'January;February;March;April;May;June;July;August;September;October;November;December';
    
    

     

    The two variants of month name can be utilized with the format codes MMM and MMMM, for example as shown in below examples.

     

    =Date(Today(), 'DD MMM YYYY')
    =Date(Today(), 'DD MMMM YYYY')
    
    

     

    In the same way as for months the DayNames can also be defined in a short and long version.

     

    SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
    SET LongDayNames ='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
    
    

     

    The two variants of day name can be utilized with the format codes WWW and WWWW, for example as shown in below examples or as in the attached example.

     

    =Date(Today(), 'WWW, DD MMM YYYY')
    =Date(Today(), 'WWWW, DD MMMM YYYY')