Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating columns based on dates, then adding data

     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.

ItemNameWeek 7/6Week 7/13Week 7/20

A

Name A101020
BName B202020
CName C102030
1 Reply
Not applicable
Author

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