Show date with week

[pippo01]

Hi everyone,

i have a date fields which i use to drill down from year to hour( year, month, day, hour).

Business requires to aggregates data also by week, starting from Monday, across months.

For example:

i need to consider 30 march - 6 april as a whole week, not 30/31 march and 1 - 6 april.

Is it possible to achive this?

in my drilldown dimension i have ='Week'&Ceil(Day(Interval)/7)

[Wlad_Masi]

Hi @pippo01 ,

Are you using master calendar?
Here are some documents for your reference: 
Understanding the Master Calendar - Qlik Sense and QlikView 
How to Create Master Calendar ?
How to create master calendar in Qlik Sense
Creating A Master Calendar

Or you should be able to just apply the function Week to your date as a new field. EX: Week(YourDate)