Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator 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
kaushiknsolanki
Luminary Alumni
Luminary Alumni

Check my reply on your other thread.

https://community.qlik.com/thread/292903

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
fvelascog72
Partner
Partner

Hi,

You can try with:

Num(Month(dateField)) as NMonth,

Saludos.

kaushiknsolanki
Luminary Alumni
Luminary Alumni

Check my reply on your other thread.

https://community.qlik.com/thread/292903

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post