Creating columns based on dates, then adding data

Wed, 08 Jul 2015 14:21:45 GMT

I need to be able to show data for the next 6 weeks but I'm not sure how to establish the columns.

I have the data that needs to go into the columns, but I'm not sure how to name the column nor the best way to show it ( ie which type of table / pivot to use). The columns needed are this week and the next 6. So every time we load if we are on to a new week, then I would like it to be dynamically creating the next column. There is specific data that needs to go into each week, which can be accumulated based on date.

Item	Name	Week 7/6	Week 7/13	Week 7/20
A	Name A	10	10	20
B	Name B	20	20	20
C	Name C	10	20	30

Re: Creating columns based on dates, then adding data

Wed, 08 Jul 2015 17:21:01 GMT

I think I answered my own question here... WeekStart is the function to use apparently.

=date(WeekStart(today()), 'MM-DD') for first label, then add 7, 14, etc for the next set of columns...

topic Creating columns based on dates, then adding data in QlikView

Creating columns based on dates, then adding data

Re: Creating columns based on dates, then adding data