Discussion board where members can get started with Qlik Sense.
I have date field with time stamp and I need to convent month_year format and write the rolling 12 months expression.
30/04/2018 12:10:11 like that. I need convent like below
and using mymonth as dimension and creating line chart with rolling 12 months expression.
How to do this. I am trying but it is not showing properly. Please help on this.
To get the monthyear, you can usethe MonthName function.
MonthName(Creation_date) as Month_Name
it will return the month and year
If you want to format the Creation_date column to Month value( 1,2,3 etc), use the below script
Date(Date#(Creation_Date,'DD/MM/YYYY hh:mm:ss'),'MM') as Creation_Month_Value
Date(Creation_Date,'MM') as Creation_Month_Value
Please try below:
Date(Date#(Creation_date,'DD/MM/YYYY HH: MM:SS'),'MMM-YYYY') as Mymonth,
I suggest you to create a master calendar, take a look at Creating A Master Calendar
Use fllowing expression in your load script :
UPPER(DATE(DATE(Creation_date,'DD/MM/YYYY'),'MMM-YYYY')) as Mymonth