topic Re: Setting a date Format in QlikView

Setting a date Format

Wed, 12 Jul 2017 03:24:28 GMT

I have some data in a field called Month. It has the format of 'MMM YY Example:

'Apr 17

'Feb 17

'Jan 17

I would like to use these as month reporting

the ' is part of the actual data

can someone help

kaushiknsolanki — Wed, 12 Jul 2017 07:21:36 GMT

Hi,

Not sure what you are looking?

Kindly explain with example.

Regards,

Kaushik Solanki

Anil_Babu_Samineni — Wed, 12 Jul 2017 07:31:03 GMT

May be one possible solution is this?

LOAD FieldName, Month(Date#(Replace(FieldName, Chr(39), ''),'MMM YY')) as FieldName2;

LOAD * Inline [

FieldName

'Apr 17

'Feb 17

'Jan 17

];

Create Tabular table with FieldName2 as dimension and metric for expression

antoniotiman — Wed, 12 Jul 2017 07:36:16 GMT

Another way

MonthName(Date#(DateField,Chr(39)&'MMM YY'))