topic Re: Generating Future Dates as a Dimension in QlikView

Generating Future Dates as a Dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I'm looking to generate a schedule going forward based on past date. I have 3 years worth of delivery data but it is important to note this does not include data on every day within that period.

I want to generate a schedule for the next year's deliveries. I can base the expected loads on at different times of year on the quantities in previous years.

I have a created a table. I want the dimension to be every day between today() and the same point next year. Obviously this data will have no existing data linked to it but by using formulas such as sum(if(month(Date)=X,ValueX)) I can attribute values to the dates.

My back up is uploading a spreadsheet with literally a years worth of dates in one column but was wondering if there was an in Qlik solution?

Thanks for any help.

Re: Generating Future Dates as a Dimension

Anonymous — Mon, 05 Dec 2016 16:57:34 GMT

You may need a Master Calendar.

Creating A Master Calendar

Re: Generating Future Dates as a Dimension

muthukumar77 — Mon, 05 Dec 2016 17:25:11 GMT

Hi,

Can you send me sample qvw file?

Re: Generating Future Dates as a Dimension

Tue, 06 Dec 2016 15:20:24 GMT

I've built the master calendar (thanks for the link). And now I can create say a filter pane or an empty table that shows future dates, however I'm having trouble using these as a dimension as there is no data to connect these to anything else.

Can you think of a way to show these future dates as a functional dimension