Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working on a load script and ran into an issue with loading data based on the first and last day of every month in a table. I have attached a copy of the table I am working with "Small Subset of data" . As you will see there is an on hand quantity for each day of a month. I need to pull the current On Hand Qty for the last day of every month so I know what the current on hand qty is for an item.
The app has two table boxes one that allows me to select a year and show me totals based on certain criteria for that year. The other table box breaks it out based on month.
I have been pulling my hair out over this one and I am sure it is something simple I am overlooking.
Thanks Everyone.
Maybe you can use a flag to identify the monthend dates:
table1:
LOAD *,
Date=DayName(MonthEnd(Date)) as IsMonthend
FROM [https://community.qlik.com/servlet/JiveServlet/download/1127255-246248/TB02_20160920_135042.xls] (biff, embedded labels, table is Sheet1$);
hope this helps
regards
Marco
Hi
creates a calculated dimensión