Displaying a date in an expression label

Thu, 17 Oct 2013 11:42:00 GMT

Hello,

Probably a very simple answer to this but I cannot get it to work.

I have various set analysis expressions to show totals for last full calendar week and the previous week to that via the code

_CurrentWeek = {1} or _PriorWeek = {1} etc

I also have a Week End date loaded to show the Sunday of the relevant week i.e currently this shows where _CurrentWeek = {1}, the Week End date is 13/10/2013

where _PriorWeek = {1}, the Week End date is 06/10/2013 etc

I would like to have the expression label to show 'Current Week' & 13/10/2013 or 'Week -1' & 06/10/2013

How can I do this please/

Thanks,

Re: Displaying a date in an expression label

CELAMBARASAN — Thu, 17 Oct 2013 11:46:39 GMT

May be something like this

='Current Week' & WeekEnd(Max({<_CurrentWeek = {1}>} Date))

='Week -1' & WeekEnd(Max({<_PriorWeek = {1}>} Date))

or If you have WeekEndDate Field

='Current Week' & Date(Max({<_CurrentWeek = {1}>} WeekEndDate), 'DD/MM/YYYY')

='Week -1' & Date(Max({<_PriorWeek = {1}>} WeekEndDate), 'DD/MM/YYYY')

topic Re: Displaying a date in an expression label in QlikView

Displaying a date in an expression label

Re: Displaying a date in an expression label