Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview data load based on date

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.

2 Replies
MarcoWedel

Maybe you can use a flag to identify the monthend dates:

QlikCommunity_Thread_233491_Pic1.JPG

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
Specialist
Specialist

Hi

creates a calculated dimensión

MonthEnd.png