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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouping 2 Week Data into 1 week


HI,

I have a requirement like need to capture data based on 2-week range dimension.

For Eg:

Period                                                 Data

2/15/2014 - 3/1/2014                             3

3/2/2014 - 3/16/2014                             15

3/17/2014 - 3/31/2014                           20

4/1/2014 - 4/15/2014                             6

4/16/2014 - 4/30/2014                            10

I am using WeekEnd_date dimension. How to capture 2 weeks data and it should not be rollingsum.

0 Replies