Qlikview data load based on date

[#1]

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.

[MarcoWedel]

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

[el_aprendiz111]

Hi

creates a calculated dimensión