Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there a way to show dates as Jun 13-21,Jun 22-28, etc

I have a client that wants to show weeks like the following:

Jun 13 - 31

Jun 22 - 28

etc....

The field I am is using is called 'Createddate'.   I have trying searching but cant seem to find anything.  Any suggestions would be helpful.

David

2 Replies
robert_mika
Master III
Master III

You can use Dual with Mapping to get this kind of result:

Question about Mapping and Dual

qlikviewaddict.com/2012/12/the-qlikview-dual-function.html

maxgro
MVP
MVP

small example

t:

load

  makedate(2015) + RowNo() -1 as date

AutoGenerate 365;

t2:

load

  date,

  dual(date(WeekStart(date), 'MMM DD') & ' - ' & date(WeekEnd(date), 'DD'), WeekStart(date)) as NewWeek

resident t;

DROP Table t;