Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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.
Table:
load
dateField ,
Month(dateField) as Month,
(Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,
'Q' & ceil(month(dateField)/3) as Quarter;
load
date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;
load * Inline [
timestampField
04/12/2017 11:57
04/12/2017 14:40
07/12/2017 12:58
08/01/2018 17:22
08/11/2017 13:24
10/11/2017 14:25
11/12/2017 16:00
];
left Join(Table)
Load * inline [
Month,MonthOrder
Jan,1
Feb,2
Mar,3
Apr,4
May,5
Jun,6
July,7
Aug,8
Sep,9
Oct,10
Nov,11
Dec,12
];
Check my reply on your other thread.
https://community.qlik.com/thread/292903
Regards,
Kaushik Solanki
Hi,
You can try with:
Num(Month(dateField)) as NMonth,
Saludos.
Check my reply on your other thread.
https://community.qlik.com/thread/292903
Regards,
Kaushik Solanki