Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

richard_chilvers
Contributor III

Dates in a week

I have a report comparing performance between 2 different weeks.

I allow the 2 weeks to be selected in format YYYYww.

Once selected, I would like to display the date range for the week selected eg.

2015 04 would have the range 25Jan2015 - 31Jan2015.

Any neat ideas how to do this ?

Thanks

Richard

1 Solution

Accepted Solutions

Re: Dates in a week

Try

= WeekStart(DateField) & ' - ' & WeekEnd(DateField)


3 Replies

Re: Dates in a week

Try

= WeekStart(DateField) & ' - ' & WeekEnd(DateField)


aushikmakdoom
New Contributor III

Re: Dates in a week

Are these weeks normal calender weeks - if so above comment should work

richard_chilvers
Contributor III

Re: Dates in a week

Thanks.

I felt sure someone would have a neat solution - I just need to sort out the formatting of DateField and it will be ideal.

Richard

Community Browser