topic Re: Qlikview data load based on date in QlikView

Qlikview data load based on date

Tue, 20 Sep 2016 18:46:40 GMT

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.

Re: Qlikview data load based on date

MarcoWedel — Tue, 20 Sep 2016 22:24:44 GMT

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

Re: Qlikview data load based on date

el_aprendiz111 — Tue, 20 Sep 2016 22:33:40 GMT

creates a calculated dimensión