Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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')