Displaying a different value for Column header in Pivot table

[pomaaa]

Hi,

I have created a Pivot table using Qlik Sense and Columns are value of months in number format. However in the header, I want them to be displayed as month name instead of number, but in the values I need them to be the number (since the data is in number). I'm not sure if I have explained it clearly so here is an example.

The field Month is =[MONTH] and I get this table:

1	2	3	4	5	...
Data for month 1	Data for month 2	Data for month 3	Data for month 4	Data for month 5	Data for month ...
Data for month 1	Data for month 2	Data for month 3	Data for month 4	Data for month 5	Data for month ...

However, in the header I want to display month name instead of number so if MONTH = 1, I want it to say January etc., like this:

January	February	March	April	May	...
Data for month 1	Data for month 2	Data for month 3	Data for month 4	Data for month 5	Data for month ...
Data for month 1	Data for month 2	Data for month 3	Data for month 4	Data for month 5	Data for month ...

Is there any way I can achieve this?

Thank you very much.

[AshutoshBhumkar · Accepted solution]

Hello,

Correct me if I am wrong. You can create a new field using Date in your data as MonthName like below.

MonthName(Date) as [Month Name]

Use [Month Name] field in Pivot

[pomaaa]

Thanks for the help.

I created a new field as you suggested but used the following formula to get the full month name since month was in number format:

Date(MakeDate(2000, [MONTH], 1), 'MMMM')