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

Announcements
Join us in Bucharest on Sept 18th 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...