topic Re: Show date with week in App Development

Show date with week

pippo01 — Mon, 20 Dec 2021 21:32:42 GMT

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 — Fri, 01 May 2020 21:06:06 GMT

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)