Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Inline help

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.

Month Order.png

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

];

1 Solution

Accepted Solutions

Re: Inline help

Hi,

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.

Regards,

Kaushik Solanki

2 Replies
agigliotti
Honored Contributor II

Re: Inline help

you don't need any script to order for month, simple order it numerically asc.

Re: Inline help

Hi,

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.

Regards,

Kaushik Solanki