Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;