Discussion board where members can get started with Qlik Sense.
Can any one please help me on below issue.
I have extracted the Month from the date field.
Then to give the order to Month I have used the below inline script.
When I have tried to left join below inline table with the main table based on Month field then the Month order is not assigned to Month.
Showing blank I need to get 1.11,12 instead of Null.
Also when I have taken Max(Month) its showing 12. I think the month is not converted properly. Please help me on this.
Please find the below script and attached app.
Month(dateField) as Month,
(Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,
'Q' & ceil(month(dateField)/3) as Quarter;
date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;
load * Inline [
Load * inline [
Go to Solution.
Change below section in your script
Text(Month(dateField)) as Month,
This will work.
Looking at your data and the way Month field is created, I dont think you need separate sorting for Month.
you don't need any script to order for month, simple order it numerically asc.