Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Extract last day of every month

Hi guys,

I have a table and I want to create a table and extract only the last day of month for every month,

2016-02-03_16h18_41.png

What do you think?

Many thank's

1 Solution

Accepted Solutions
sunny_talwar

PFA the application.

View solution in original post

15 Replies
sunny_talwar

In the script? May be this after your load statement:

Right Join (AboveTable)

LOAD Date(Floor(MonthEnd(created))) as created

Resident AboveTable;

settu_periasamy
Master III
Master III

May be like this.. after loading your first table

Monthend_Table:

LOAD created,ItemId,stock

Resident Firsttable where created=MonthEnd (created);

ecabanas
Creator II
Creator II
Author

Hi Settu,

The problem is that your script only takes the last month, not the last date of the 3 months

many thank's

ecabanas
Creator II
Creator II
Author

Hi Sunny,

Here we are again 🙂

the problem is I want to created a sepparated table to know the end month stock position, why right join?

many thank's

sunny_talwar

Oh so you want all data in your application, but just restrict it in one chart on the front end?

Not applicable

Something like this

A:

Load

Created,

Item ID,

stock

From

[xxxxxxxxx.xlsx];

left Join (A)

LOAD

Item ID,

max(Created) as [Maxdate in the Month]

Resident  A

group by Item ID ,Month(Created);

sunny_talwar

Something like this?

Capture.PNG

ecabanas
Creator II
Creator II
Author

yes Sunny!!!!that's it!!

sunny_talwar

Awesome,

If you got what you needed, would you mind closing this thread down by marking correct and helpful answers.

Best,

Sunny