Week Dimension Start and End Date

[akuttler]

Hello,

Can I create a custom dimension that is the Week(Date) Displayed as the start and end date?

For example if week(Date) =  2

It would be displayed as '01/07/2018 - 01/13/2018'

Thanks.

[Digvijay_Singh · Accepted solution]

I think you can use Dual for that, something like this -

Dual(Weekstart(Date)&'-'&Weekend(Date),week(Date))

[yujiyamane]

Try below in your load script.

TEXT(Date(Floor(WeekStart(***Date field***))))& ' - ' & TEXT(Date(Floor(WeekEnd(***Date field***)))) as WeekStartEnding,

[pablolabbe]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

[akuttler]

Thank you this is what I was looking for,  just one field so I don't have to also specify the week #.

[akuttler]

[mahaveerbiraj]

Hi Digvijay ,
Why you using Dual () function