Discussion Board for collaboration related to QlikView App Development.
I have a table and I want to create a table and extract only the last day of month for every month,
What do you think?
PFA the application.
View solution in original post
In the script? May be this after your load statement:
Right Join (AboveTable)
LOAD Date(Floor(MonthEnd(created))) as created
May be like this.. after loading your first table
Resident Firsttable where created=MonthEnd (created);
The problem is that your script only takes the last month, not the last date of the 3 months
Here we are again 🙂
the problem is I want to created a sepparated table to know the end month stock position, why right join?
Oh so you want all data in your application, but just restrict it in one chart on the front end?
Something like this
left Join (A)
max(Created) as [Maxdate in the Month]
group by Item ID ,Month(Created);
Something like this?
yes Sunny!!!!that's it!!
If you got what you needed, would you mind closing this thread down by marking correct and helpful answers.