This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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