Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

PFA the application.

View solution in original post

15 Replies

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

Right Join (AboveTable)

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

Resident AboveTable;

May be like this.. after loading your first table

Monthend_Table:

LOAD created,ItemId,stock

Resident Firsttable where created=MonthEnd (created);

Creator II
Creator II

Hi Settu,

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

many thank's

Creator II
Creator II

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

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);

Something like this?

Capture.PNG

Creator II
Creator II

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

Awesome,

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

Best,

Sunny